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.
I have a product table and It has a column ProductType. I have a created a matrix visual where I dragged this ProductType column in the Row Header.
I want the data should look like this
But when I am changing the color from the properties area, I am only able to assign one color for the entire ProductType Column. I want to assign different color for each ProductType value ( like above)
Thanks
Solved! Go to Solution.
Hi @amikm ,
Creating a matrix by dragging the column to the canvas .
First Create a table with Product Type and color .
Now create a relationship betweem the Product Type column in Main Table and newly created table .
Note : You could also add a column to the existing table and add the color names as well .By doing this you won't need to create a new table and create relationship .
Go to Cell Element and turn on the Font Color For the column "Product Type" .Now click on fx below the Font Color toggle button
Now keep the formatting as shown the image below.
Now you will get the desired result.
Thanks
Proud to be a Super User!
Hi @amikm ,
Creating a matrix by dragging the column to the canvas .
First Create a table with Product Type and color .
Now create a relationship betweem the Product Type column in Main Table and newly created table .
Note : You could also add a column to the existing table and add the color names as well .By doing this you won't need to create a new table and create relationship .
Go to Cell Element and turn on the Font Color For the column "Product Type" .Now click on fx below the Font Color toggle button
Now keep the formatting as shown the image below.
Now you will get the desired result.
Thanks
Proud to be a Super User!
Hi @amikm
You have to create the flag ID based on ProductType.
And you can create fuction rules to change the colour of rows
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 |