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

Подписаться 13 тыс.

Просмотров 17 тыс.

50% 1

This video demonstrates a few powerful techniques to highlight values or data points that are above or below average in a chart, going beyond the built-in reference line functionality in Power BI. Learn how you can apply conditional formatting in a line chart with a simple tweak, and finally, I will build a dynamic average calculation using DAX to work in different levels of a date hierarchy.
Video Timestamps
0:00 - Intro
0:48 - Example 1 - Add average reference line to a chart using the built-in option.
2:31 - Example 2 - DAX average calculation with conditional formatting and a line chart trick.
6:54 - Example 3 - Dynamic DAX average calculation on a date hierarchy and average line.
16:13 - Ending
🟠 You may download the completed PBIX file here:
excelfort.com/highlight-above...
🟠 For Instructor-led virtual training programs, visit:
👨‍🏫 excelfort.com/training/ or 📧 info@excelfort.com
🟠 LET'S CONNECT!
------------------------------------------------------
-- / excelfort
-- / excelfort
-- / fowmy
#powerbi #datavisualization #dax #dataanalytics #excelfort

Опубликовано:

7 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 16

@elimcd1979 2 года назад

Very cool trick!

@Nxnxnxnx904 3 года назад

Thanks for sharing

@LongHuynh-hf7ck 2 года назад

Thanks a lot! Very helpful

@ExcelFort 2 года назад

You are welcome 🙏

@payalrana1574 3 года назад

Very helpful

@shiranarsakularathne9517 Год назад

Thanks for the knowledge shared

@ExcelFort 11 месяцев назад

Glad you like it

@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

@LearnAllways 2 года назад

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

@ExcelFort 2 года назад

That’s a superb idea to make a video on! Please send me some sample data and the expected results to my email: info@excelfort.com

@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.??

@chandramohan1418 3 года назад

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

@ExcelFort 3 года назад

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

@zagaaru 2 года назад

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 2 года назад

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