Forum Discussion
conditional formatting doesn't work
Hi,
I've created a table with three measure and the result is a table with only one row that shows the total of each measure.
I've applied conditional formatting to one measure but it doesn't work, why?
In attached an example
Thank you
Giada
13 Replies
it depends on:
a) how exactly do you calculate your measure
b) how exactly do you implement conditional formatting
please, provide details
Total sales is sum of column Sales and Total profit is Sum of column Profit, I want to create a conditional formatting of Total Sales, something like this:
But it doesn't color anything
This is just an example.
What I want to do in real data is something like conditional formatting in total rows in a table
Giada_Togliatti , refer if these can help
Conditional formatting
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692amitchandak , Tahreem24 , az38 I've applied the same conditional formatting I need (a conditional formatting based on another measure) and it works, why if I tried to use the same in a table like the attached on it doesn't work?
In attached an example: if I add a dimension like product name and I have more rows it works
If I remove product name is again without color
This is my question, I hope I've explained well my problem in real case
it depends on your measure statements
