Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I need to keep the below indicators visuals in my Power BI report based on the values.
If issue count is < 10, then it should appear with Red color including a image in it. Like that it differes for warning and as per plan colors and images.
How can we peroform it ?
Solved! Go to Solution.
Actually for the color you can use color measure. That you can use in background color
Color Measure = if([count]<10, "red", "green") Or switch true for more option .
You can also have an image URL on the measure, but I have not tested that.
May be, create a measure that returns a different image URL. Where you want to use I am not clear.
Color measure you can use in background /conditional formatting with Field value option
Hi @Anonymous ,
According to my test, I can change the background color outside the picture range.
Create the following measure and apply it to the conditional formatting of the background color.
Measure 2 = var count_ = CALCULATE(COUNT('Table'[type]),FILTER(ALLSELECTED('Table'),'Table'[type]="Schedule"))
return SWITCH(TRUE(),
count_>10,"red",
count_>5&&count_<=10,"yellow",
count_<=5,"green"
)
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
You can try encoding your image in base64 and use it in your measure. Mark the data type of measure as image URL and you are good to go.
Reference - https://community.powerbi.com/t5/Desktop/Base64-Images/m-p/737648
Actually for the color you can use color measure. That you can use in background color
Color Measure = if([count]<10, "red", "green") Or switch true for more option .
You can also have an image URL on the measure, but I have not tested that.
May be, create a measure that returns a different image URL. Where you want to use I am not clear.
Color measure you can use in background /conditional formatting with Field value option
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |