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.
Working to build a horizontal bar chart with values below "x" say 50, going to the left and above going to the right.
Example Store A has 80 widgets and Store B has 30 widgets
The chart list Store A and B on the X axis, store A would have a bar going to the right "starting from 50", and store B would have a bar going to the left "starting from 50".
Solved! Go to Solution.
You could consider this workaround.
Use Tornado 1.3.0 visual, then create calculated column
category = IF([widgets]=50,"starting from 50",IF([widgets]>50,"over 50","less 50"))
Then add "line" and "text" on the visual
Best Regards
Maggie
Hello all,
Do you know if there is an equivalent of the tornado chart for Vertical bar chart with custom y axis "zero point" ?
Thanks in advance,
Numa
After searching, I can't find a visual which is able to meet your requirement exactly.
Here is a workaround.
Created calculated columns, then add columns in a stacked bar chart.
Widgets 2 = IF([widgets]=50,0,IF([widgets]>50,[widgets]-50,[widgets]-50) ) category = IF([widgets]=50,"starting from 50",IF([widgets]>50,"over 50","less 50"))
The line in the middle of the chart is a constant line.
Best Regards
Maggie
Hi Maggie, this is very close. The axis and data value still need to read the reported actual value.
Example, the first bar needs to display the number 80 and grow from 50 versus the reported calculated value of 30, same with the bars going to the left. The second bar would report 30 and not -20 and start from 50, the reported values/labels need to be the actual value
How is this accomplished?
You could consider this workaround.
Use Tornado 1.3.0 visual, then create calculated column
category = IF([widgets]=50,"starting from 50",IF([widgets]>50,"over 50","less 50"))
Then add "line" and "text" on the visual
Best Regards
Maggie
good solution, thanks 🙂
This is great, thanks Maggie!
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |