Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
How can we change the data values color in a clustered bar chart when it was overlapped with the graph itself? Please see below example:
Solved! Go to Solution.
There's currently no option to do that, but it is possible to set the values to only inside / outside if you need.
The other alternative I found is a work-around. It's possible to format the colour of the data labels conditionally... but this point in time, I can't apply the condition of whether the point is inside or outside the bar.
Instead, I was able to split my measure into two - "small" values and "big" value
s and create a chart with them both.
I can then format the position of the data labels on each separately.
Measures used in the chart:
Data Label Settings:
|
Resulting chart:
HTH
Pi
You're welcome! Please remember to mark whichever answer helped as a solution 🙂
Thank you @PiEye Is it possible to set it to be dynamic? To change to white if the graph overlaps with the datavalues?
There's currently no option to do that, but it is possible to set the values to only inside / outside if you need.
The other alternative I found is a work-around. It's possible to format the colour of the data labels conditionally... but this point in time, I can't apply the condition of whether the point is inside or outside the bar.
Instead, I was able to split my measure into two - "small" values and "big" value
s and create a chart with them both.
I can then format the position of the data labels on each separately.
Measures used in the chart:
Data Label Settings:
|
Resulting chart:
HTH
Pi
User | Count |
---|---|
47 | |
26 | |
22 | |
17 | |
15 |
User | Count |
---|---|
53 | |
34 | |
17 | |
17 | |
15 |