Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
Hi everyone,
I have a line chart with revenue per month. I want the lowest and the highest month highlighted with red for low and green for high. I used this video: https://www.youtube.com/watch?v=hmk6PxDtbNs&t=0s
And created this measure:
MaxMin Omzet =
VAR Omzet = [Omzet]
VAR MAXOmzet =
MAXX(
ALLSELECTED(Datumtabel[Jaar], Datumtabel[Maand], Datumtabel[Maandnr]),
[Omzet]
)
VAR MinOmzet =
MINX(
ALLSELECTED(Datumtabel[Jaar], Datumtabel[Maand], Datumtabel[Maandnr]),
[Omzet]
)
VAR Result =
SWITCH(
TRUE(),
[Omzet]=MAXOmzet, “Green” || [Omzet]=MinOmzet, “Red”,
“blue”
)
RETURN Result
The video says to turn it to a column chart and with column color select the fx next to color. then select field value and then the measure. But I cannot select the measure. I have tried setting the measure to text, but that is not an option. What am I doing wrong?
Make sure you created a measure and not a calculated column
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.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 51 | |
| 37 | |
| 35 | |
| 19 | |
| 17 |
| User | Count |
|---|---|
| 70 | |
| 64 | |
| 39 | |
| 33 | |
| 23 |