Conditional formatting in field paramete

[aAmirkHan]

Hi,

I am trying to make this visual which changes color based on average line in field parameter by taking example from below report.

Can you please help and advise how to build this report? Please refer below screen shot for your reference along with report link.

Report Link:

Restaurant Power BI Report

Thank you

Kind Regards,

Aamir

[barritown]

Hi @aAmirkHan,

The solution may vary depending on your dataset, but the idea is:

1) You create a measure to calculate some average parameter:

Avg Sales = AVERAGEX ( SUMMARIZE ( Data, Data[Period], "Week Sales", CALCULATE ( SUM ( Data[Sales] ) ) ), [Week Sales] )

2) You use this measure to define the colour with another measure like this:

Colour = 
VAR AvgSales = CALCULATE ( [Avg Sales], ALL ( Data ) )
RETURN IF ( SUM ( Data[Sales] ) > AvgSales, "gray", "orange" )

3) Then you apply it as a conditional colour - and it works:

Please check the attached PBIX file.

If you wish to link it with a field parameter slicer, no problem - you need just to link it to the right value and modify the initial measure so it takes into account, which parameter is chosen there.

Update: I've added a slicer and alternative line to illustrate the approach.

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian