Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Dynamic conditional formatting

Instead of hardcoding a number to use on formatting a table, allow users to use a measure/calculation (DAX) to format dynamically a table.
Status: Completed
Comments
andrevioti
New Member
Please add
kzwyers
Frequent Visitor
Please add
ardalan_sepehri
New Member
Conditional formatting based on the values of another table (actual vs. target)
alves_mitch
New Member
This is a MUST!
rtroncoso
New Member
In Tableau there is something called "a paremeter". It would be helpful here!
fbcideas_migusr
New Member
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()) 2018,"red","yellow")) Color = if(FIRSTNONBLANK(Table[Year],2014) <=2016 && AVERAGE(Sales[Sales Amount])<170 ,"lightgreen",if(FIRSTNONBLANK(Table[Year],2014)>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" )
nishalit
New Member
This is available already! You can read more about conditional formatting here: Table visualizations in Power BI reports and dashboards - Power BI | Microsoft Docs
fbcideas_migusr
New Member
Status changed to: Completed