Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have a table looks like:
Station | Test Result |
Station1 | Pass |
Station2 | Fail |
Station3 | Pass |
Station4 | Pass |
Station5 | Pass |
Station6 | Fail |
I want to show it as following:
Pass | Fail | Pass |
Pass | Pass | Fail |
or
What visual should I use?
Thanks in advance.
Solved! Go to Solution.
Hey @kongyuancn ,
unfortunately there is no default and also no custom visual that allows the visualization the way you want.
This is because of the visualization does not think in linebreaks or new lines every three. Currently all the stations will be shown in one column, meaning 6 rows, or one row, meaning 6 columns.
If you can add two additional columns (row / column) to your data, that will define the position in a matrix you can use a matrix visual. So Station1 has the values row:1 and column:1, Station5 has the values row:2 and column2.
Hopefully, this provides some ideas to tackle your challenge.
Regards,
Tom
There is no direct way to create such visualization, but as I realized your data I think there is a way around
- Create Index Column against your data (Power Query)
- Create Grouping Column this will group your data in 3
Grouping Column = IF( MOD('Table'[Index],3) =0,3,MOD('Table'[Index],3))
-Create a Custom Column Cieling Column that will give you Row Grouping
Ceil = CEILING('Table'[Index]/3,1)
- Put Ceil in Row, Grouping Column in Column and TestResult in Values in Matrix to get following results, you can do conditional formatting and change the column header color to white to get more appropiate result.
I hope this is what you are looking for.
Proud to be a Super User!
There is no direct way to create such visualization, but as I realized your data I think there is a way around
- Create Index Column against your data (Power Query)
- Create Grouping Column this will group your data in 3
Grouping Column = IF( MOD('Table'[Index],3) =0,3,MOD('Table'[Index],3))
-Create a Custom Column Cieling Column that will give you Row Grouping
Ceil = CEILING('Table'[Index]/3,1)
- Put Ceil in Row, Grouping Column in Column and TestResult in Values in Matrix to get following results, you can do conditional formatting and change the column header color to white to get more appropiate result.
I hope this is what you are looking for.
Proud to be a Super User!
Hey @kongyuancn ,
unfortunately there is no default and also no custom visual that allows the visualization the way you want.
This is because of the visualization does not think in linebreaks or new lines every three. Currently all the stations will be shown in one column, meaning 6 rows, or one row, meaning 6 columns.
If you can add two additional columns (row / column) to your data, that will define the position in a matrix you can use a matrix visual. So Station1 has the values row:1 and column:1, Station5 has the values row:2 and column2.
Hopefully, this provides some ideas to tackle your challenge.
Regards,
Tom
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |