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
Is it not same as Color measure using field Option
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
examples of such meaures - And these work fine on table and Matrix .
Color Date = if(FIRSTNONBLANK('Date'[Date],TODAY()) <=2016 && AVERAGE(Sales[Sales Amount])2018,"red","yellow"))
Color sales = if([Sales Today] -[sales yesterday]>0,"green","red")
color =
switch ( true(),
FIRSTNONBLANK(Table[commodity],"NA") ="commodity1" && sum(Table[Value]) >500,"lightgreen",
FIRSTNONBLANK(Table[commodity],"NA") ="commodity2" && sum(Table[Value]) >1000,"green",
/// Add more conditions
"red"
)
RE: Dynamic conditional formatting
In Tableau there is something called "a paremeter". It would be helpful here!
RE: Dynamic conditional formatting
Conditional formatting based on the values of another table (actual vs. target)
RE: Dynamic conditional formatting
This is a MUST!
RE: Dynamic conditional formatting
Please add
RE: Dynamic conditional formatting
Please add
RE: Dynamic conditional formatting
Yes, basic functionality in RS should be available in Power BI
RE: Dynamic conditional formatting
Yes! And if possible, a stoplight (red, yellow, green). Such like x have been completed within date, yellow are not completed but within expected end date, and red that have not been completed and have reached or exceeded end date.
RE: Dynamic conditional formatting
definately need this - having the ability to build an expression based on all formatting is needed.
RE: Dynamic conditional formatting
Yes!!! Really need this feature!