Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |