Highlight Values Above & Below Average in Power BI with DAX and Conditional Formatting

[@elimcd1979]

Very cool trick!

[@santoshhmt]

Hi It's helpful If possible please make a video on below use case 1. When we are in first month means Jan how it looks 2. If any month or any full quarter there is no sale how it looks 3. Alternative months no sales like that for quarter's too. 4. Instead of average can we set target If above target means red below means means also red If between below and above then green

[@Nxnxnxnx904]

Thanks for sharing

[@LongHuynh-hf7ck]

Thanks a lot! Very helpful

[@ExcelFort]

You are welcome 🙏

[@shiranarsakularathne9517]

Thanks for the knowledge shared

[@ExcelFort]

Glad you like it

[@payalrana1574]

Very helpful

[@voiceofpallavi4776]

Hi Excel Fort, In the line chart if I add product category in Legend then the conditional formatting breaks. so in this case how should I apply this conditional colour.??

[@LearnAllways]

Could you please do the video for Average time, like per day average talk time/hold time/production time etc...

[@ExcelFort]

That’s a superb idea to make a video on! Please send me some sample data and the expected results to my email: [e-mail]

[@chandramohan1418]

could yu pl start from Basic to Advanced PQ and PowerPiovt.thank yu

[@ExcelFort]

Thanks for your suggestion. Stay tuned, I am planning on beginner series.

[@zagaaru]

Excel Fort, i like the video but how did you create the Sales Amount measure,I am beginner to DAX, could you please clarify how you created Sales amount measure?

[@ExcelFort]

Glad you liked it! Yes, I had created a sales measure: Sales Amount = SUM( 'Sales Data'[Sales] ) Download the file from the link in the description