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,
Based on below Sample Table Data, I have tried and able to display the data in Matrix visual as below, BUT need help
Need help and inputs:
1) how to display Region as a column in Matrix visual ?
2) how to add conditional formatting to the Region column value to set some background color.
If the requirement (points 1 & 2 )can be acheived in Table visual then it will also help
Expected Visual mockup:
Sample Table Data
Region | Location | Item | Volume |
Region1 | Location4 | Item2 | 44 |
Region1 | Location4 | Item1 | 44 |
Region1 | Location4 | Item6 | 55 |
Region1 | Location2 | Item4 | 44 |
Region1 | Location3 | Item2 | 44 |
Region1 | Location3 | Item1 | 44 |
Region1 | Location3 | Item8 | 44 |
Region1 | Location3 | Item4 | 44 |
Region1 | Location3 | Item3 | 44 |
Region1 | Location3 | Item6 | 44 |
Region1 | Location3 | Item5 | 44 |
Region1 | Location3 | Item7 | 44 |
Region1 | Location1 | Item4 | 44 |
Region1 | Location1 | Item7 | 44 |
Region1 | Location5 | Item4 | 55 |
Region1 | Location5 | Item7 | 55 |
Region1 | Location7 | Item2 | 55 |
Region1 | Location7 | Item8 | 66 |
Region1 | Location7 | Item4 | 55 |
Region1 | Location7 | Item3 | 55 |
Region1 | Location7 | Item6 | 55 |
Region1 | Location7 | Item7 | 66 |
Region1 | Location6 | Item4 | 55 |
Thanks.
Solved! Go to Solution.
Thought to share : I was able to display Region column using Matrix Visual
Below are the steps,
1) Select the Matrix visual --> Click Format icon --> Go to Row headers and turn off the "Stepped Layout" feature.
2) Drag the RegionName to the Rows Field.
Thought to share : I was able to display Region column using Matrix Visual
Below are the steps,
1) Select the Matrix visual --> Click Format icon --> Go to Row headers and turn off the "Stepped Layout" feature.
2) Drag the RegionName to the Rows Field.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |