on 01 Nov 2016 02:45:10
Instead of hardcoding a number to use on formatting a table, allow users to use a measure/calculation (DAX) to format dynamically a table.
Administrator
This is available already! You can read more about conditional formatting here: Table visualizations in Power BI reports and dashboards - Power BI | Microsoft Docs
- Comments (56)
RE: Dynamic conditional formatting
please add this feature.
RE: Dynamic conditional formatting
Please add the possibility to include this!!!
RE: Dynamic conditional formatting
I am waiting for this feature desperately. Please microsoft include this feature ASAP.
RE: Dynamic conditional formatting
I can not believe that this was missed. Come on Microsoft. This is too basic to not have. Even in Excel we can enter a formula. Excel had this since the beginning. This should be easy to add. Hope it is very soon!
RE: Dynamic conditional formatting
I agree and can't believe this isn't available. I've moved across from SSRS where this is all available through expressions so why not in Power BI?
I'm working on a data warehouse project and need to compare my fact KPI's against thresholds stored in my dimension tables. Need this desperately!!
RE: Dynamic conditional formatting
This is really a simple additional feature surely - works in every other MS product!
RE: Dynamic conditional formatting
My business users are seriously requesting the ability to alter the color of a TEXT value as opposed to NUMBER values in a table. If I can format Column X using a value from Column Y or Column Z, that would satisfy them.
RE: Dynamic conditional formatting
I really need this feature since the many customers asked to incorporate conditional formatting based on parameter selection. For e.g. Condition based on the what if Parameter slicer. This would increase the flexibility of defining conditions in Matrix visual or Table Visual. Even this should be applicable in column and Bar charts.
RE: Dynamic conditional formatting
Pity that it PBI is not able to use the output of other colums to add conditional formating colours. Example= if i have a column ACTUAL and a column BUDGET, then i want to have my Actual in red in case the amount is bigger than Budger. This is not possible unless i create a new calculated column but this is not the proper solution. So, please make it work.
RE: Dynamic conditional formatting
Being able to apply conditional formatting based on different measure/dimension than displayed in the values is crucial to provide concise and clear information with little visible elements on the screen. It's really useful and requested in vast majority of cases