Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
Hello.
I'm working with the mapbox visualization. The case is such that I have chosen three colors (screenshot attached). This color shows how much a item is filled. Represents the fill rate of an object.
Green color = Lots of space
Yellow color = Half full
Red color = Soon full
The problem is that I will only show these three colors, but the scaling will not be correct. As you can see on the screenshot attached, the scaling changes colors when it approaches one of the selected colors. Such as orange in this case. I only want to show the selected three colors? How can this be achived?
Thank you in advance.
Solved! Go to Solution.
Hi @Anonymous,
There could be more than three values. How can the MapBox know which is small, which is big? Since you just need three colors, we can group the values like below.
Measure 12 =
VAR total =
SUM ( Table34[Index] )
RETURN
IF ( total < 30, 1, IF ( total < 90, 2, 3 ) ) // adjust the values to your needs.
Best Regards,
Dale
Hi @Anonymous,
There could be more than three values. How can the MapBox know which is small, which is big? Since you just need three colors, we can group the values like below.
Measure 12 =
VAR total =
SUM ( Table34[Index] )
RETURN
IF ( total < 30, 1, IF ( total < 90, 2, 3 ) ) // adjust the values to your needs.
Best Regards,
Dale
Thanx alot for ur help! Works perfectly.
Cheers Mate
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.
| User | Count |
|---|---|
| 48 | |
| 40 | |
| 40 | |
| 20 | |
| 16 |
| User | Count |
|---|---|
| 70 | |
| 67 | |
| 32 | |
| 27 | |
| 26 |