Forum Discussion
DAX with conditional formatting
Hi, I am using Power Automate Flow and filter column from Power BI report using 'Run a query against a dataset' and the Query Text is using SUMMARIZECOLUMNS. Example: SUMMARIZECOLUMNS( ...
Hi Azhar80
If you want to set the font color , you always have to use conditional formatting. I created a sample , you can refer to it .
Create a measure like this :
Measure = SWITCH(TRUE(),SELECTEDVALUE('Table'[Column1])<0.75, "#DB271C")
I have attached my pbix file .
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your reply Anonymous , I do understand how to do it in Power BI report, but I actually want it only in DAX Query, to use it in my Power Automate flow, DAX Query - "Run a query in a dataset". Anyway, thanks for your help.