Power BI - Dynamic Gauge Color (Expression-Based Formatting #2) 

Been cracking this one for a long time, thanks!

This is same as my client requirement since 2 days i was looking for gauge chart color formatting should be dynamic Its really amazing and easy way thank you so much god bless you..

Just hit your post when trying to figure this out. Easy, simple and above all dynamic 👍🏻 Thanks a lot

Hi, how did you set the slicer to show only one vale and not Max and Min as it's supposed to be?

Thanks a lot, Parker- have been looking for something simple and easy like this! :)

Hi, what if i have two maesures ? trend and target ? for example trend > target = green trend

why do you use measure ? target, min value, max value can be set using your visual format menu, right?

Is it possible to let it shows both the actual value and its percentage as the max value?

Does this only work with measures for the parameters or can you use existing fields from imported excel data?

Thanks will try it tomorrow

do you have the file for us to practice?

This helps a lot :)

Awesome!!!

nice video!

Thanks man!

Hi, Great video ! But am I the only one to have the color measure greyed and unable to assign it as field value in the conditional formatting ?

Thanks for your video. Can we do in two color if goal is greater than 80 then green color and remaining 20 in red color? I mean it shows 2 color in gauge.

Hi Parker! Your videos are very helpful. Can you also create a video where in the Month to date and Week to date values adjust together with the Date Slicer in the report? This would be a very great help for my organization. Thank you!

help Hello Please please I need your help it’s very urgent I need to calculate our company employees net salary , I have two tables First table: come from our finger print system have the employee clock in and clock out with columns ( employee id, date, time in and out) Second table : have the requests send by every employee if his late or absent ( employee id, request type such as sick leave or excuse, and date) The challenge is I want to join these two tables to make some calculations such as if he is absent will deduct two days from his salary if he didn’t send a sick leave. I don’t know how to connect both of them , I try every thing I have learned such as merge or append queries I also try to model it in power bi but it doesn’t work at all time

Low audio