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,
I have a column in a table called display type which has values sum and normal. I've built a matrix around this table.
I'd like to colour code display type values for sum but i don't want the column display type to be shown on the matrix.
Is there a way to do this?
Thank you.
Solved! Go to Solution.
Hi @Anonymous ,
Please create a measure and add it to Conditional formatting rule as below.
Measure = IF(SELECTEDVALUE('Table'[type])="sum",1,0)
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Please create a measure and add it to Conditional formatting rule as below.
Measure = IF(SELECTEDVALUE('Table'[type])="sum",1,0)
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-jayw-msft I don't see the measure in the conditional formatting part. Do I have to add this to the visual (which i don't want to do).
Thank you.
Hi @Anonymous ,
You don't need to add the measure to visual.
Please check this pbix.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous
Need little more information to answer your question.If you only want to conditional format display type -sum, you could use the selected value inside switch statement to check "display value =sum" and set the hex color code else none. Then you could use this measure in conditional format.
Refer to the documentation.
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting
Show us the expected output.
If this helps, mark it as a solution
Kudos are nice too
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |