100% dynamic control over rows, columns & formatting using only visual level filters
Hi Sorry I was just wondering if it was possible to conditional format the values based on a rule.
I.e if the value shown is <0, show this as red, otherwise show it as black.
I can't figure out what the dax would be to be able to add it to the cell elements font colour.
Thanks
Hi, that should be possible if you make sure the data type of the measure shown in table is numeric.
Thanks Lasse, all good. I figured out what I was doing wrong anyway! Thanks again.
Hi, I just subscribed and downloaded the report, however I was unable to open it due to an unsupported table name. Please can you advise, thanks!
Hi, it looks like that February update to Power BI Desktop removed the possibility to call the measures table " Measures".
I've uploaded a fixed pbix to the resources now. Let me know if it works
I am subscribed but not able to get the Pbix files
The link comes with the welcome email when you subscribe
Hi Sorry I was just wondering if it was possible to conditional format the values based on a rule.
I.e if the value shown is <0, show this as red, otherwise show it as black.
I can't figure out what the dax would be to be able to add it to the cell elements font colour.
Thanks
Hi, that should be possible if you make sure the data type of the measure shown in table is numeric.
Thanks Lasse, all good. I figured out what I was doing wrong anyway! Thanks again.
Hi, I just subscribed and downloaded the report, however I was unable to open it due to an unsupported table name. Please can you advise, thanks!
Hi, it looks like that February update to Power BI Desktop removed the possibility to call the measures table " Measures".
I've uploaded a fixed pbix to the resources now. Let me know if it works
I am subscribed but not able to get the Pbix files
The link comes with the welcome email when you subscribe