Forum Discussion

LamdaLamda's avatar
LamdaLamda
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Conditional formatting of Measure in a Table

Hi All,   Is it possible to conditionally format a measure inside a table visual?  I have pulled 5 metrics into my table visual, all are measures, and am looking to format my last two columns to sh...
Need Help
dax's avatar
dax
Icon for Community Support rankCommunity Support
6 years ago

Hi LamdaLamda , 

I am not clear about your requirement and data structure, if possible could you please inform me more detailed information(such as your expected output and your sample data, you could use virtual data instead of real data)? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

LamdaLamda's avatar
LamdaLamda
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

I figured it out on my own - the issue is that PBI will not include conditional formatting of a table if there is no category included in it.  My group just wanted 5 KPI's so it would not work.  You have to include some type of category/main point to the table like company, area, something to tie it altogether.  This should be an upgrade - the need for a category or supporting column to allow conditional formatting makes no sense.  Just allow people to format a metric, column, etc.  however they want - don't force another dimension onto it.