Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Power BI friends,
I would like to add a dynamic label (8.01% in the example) on the last value of this line in this bar-line-chart.
The best sollution i could find was this:
However i don't like this sollution for 2 reasons: the 'hidden' white bar is ugly and interupts the gridlines.
And this label on the max-line you can't edit the font-size.
Can someone help me creating the first chart but with a single label at the end of the line. (simular to the label in the second chart)?
PBIX: https://drive.google.com/file/d/10NtR0ZuYkKbEWjZtDK6rgi6wm50xjvXr/view?usp=sharing
Thanks!
JVH_DA
HI @JVH_DA,
AFAIK, current 'constant line' only supports static values, you can't use it with measure expressions.
For this scenario, maybe you can try to switch to clustered column chart to which support more analysis lines and contains expression based lines. (notice: these lines only support the measure formula that you used on value fields, you can't set to them to show the measure formula result not used in your chart)
BTT, you can also consider submitting an idea for added support for using expressions on the constant line.
Regards,
Xiaoxin Sheng
You could do this with a custom visual using Charticulator, but it might be easier to just position your card with that value onto the chart instead. Would that work?
Can You Say "Charticulator"? - I Knew You Could - Portland Power BI UG - YouTube
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Yes, I could move the card over the viz, or use an extension. The problem with the card is that the line is never on the same height in the carth, because of slicers.
Was hoping to find a more elegant solution using dax to add a new measure to the line. You think that might be possible? Or is your solution as good as it gets.
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |