Applying Field Based Conditional Formatting as a Best Practice

No video

Applying Field Based Conditional Formatting as a Best Practice

Рет қаралды 4,717

Күн бұрын

Learn about a great technique when applying measure-based conditional formatting to visualizations in Power BI. This technique will help significantly reduce development time. PBIX file is available at the Blog Files link below.
LET'S CONNECT! 🧑🏽‍🤝‍🧑🏽 🌟
-- / havensbi
-- / reidhavens
-- / havensconsulting
HAVENS CONSULTING PAGES 📄
Home Page - www.havensconsu...
Blog - www.havensconsu...
Blog Files - www.havensconsu...
Files & Templates - www.havensconsu...
Consulting Services - www.havensconsu...
Contact & Support - www.havensconsu...
EMAIL US AT 📧
info@havensconsulting.net
#PowerBI #PBI #microsoftpowerbi #HavensConsulting #powerplatform #microsoft #businessintelligence #datascience #office #data #digitaltransformation #dataanalytics #tableau #excel #powerapps #datavisualization #dashboard #sharepoint #python #bi #analytics #cloud #azure #bigdata #sqlserver #software #sql #dynamics #dataanalysis #yammer #microsoftpowerbi #onedrive #machinelearning #bhfyp #powerbidesktop

Пікірлер: 13

@NirRobinson 5 жыл бұрын

Great tip! 🙏🙏 Can save hours and frustration when need to update the color 😇

@HavensConsulting 5 жыл бұрын

Thanks!

@mustafabiviji00711 3 жыл бұрын

Very good tip - really would help standardizing colors even across multiple reports (by using same code).

@gonzalorengifo1031 5 жыл бұрын

Great tip! I tried it with a measure within the SWITCH command and it worked perfectly. Remember to type the # before the Hex color code, example #FF0000

@HavensConsulting 5 жыл бұрын

Thank you! Yeah the # needs to be included for it to work

@koutlaw30 3 жыл бұрын

Exactly what I was looking for...Thanks!!!!

@HavensConsulting 3 жыл бұрын

Glad I could help!

@mshparber 4 жыл бұрын

Excellent!

@mshparber 5 жыл бұрын

Excellent! Thanks!

@vishalpatil4102 3 жыл бұрын

How did you do this? Can you show the practical demo also please

@Nanzur 5 жыл бұрын

This is awesome. Do you use a calculated column to set your kpi value? What context would you suggest to set from a fact_Sales vs a Monthly target? I mean, do you have any DAX tips to optimize it?

@shoaibtanvir3560 4 жыл бұрын

I am trying to create a Gauge where any value exceeding target should be in different color. Eg:. If 100 is my target and 120 is my actual value then 100 will show in Green and 20 (120-100) will be in Red. can someone please help me on this.

@HavensConsulting 4 жыл бұрын

Hi there, unfortunately this isn't possible today as the gauge car can only be conditionally set to one color at a time.