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.
Hello everyone!
I was trying to make a chart like this one (data labels are not required they are there just so the chart is easier to understand):
After filtering the data with filtering visual objects I can get a set of data like the following:
bars [230, 150, 90]
upper red line [210,210,210]
downer red line [90, 90, 90]
black line percentages [0.5, 0.3, 0.2]
As you can see, columns and red lines use the left Y-axis to represent their values while the black one use the right one, is this achievable by using this tool?:
Because I haven't been able to reproduce it and this is what I get because all lines use the right Y-axis:
Thanks before hand,
Yours faithfully,
Zaloon.
Solved! Go to Solution.
Hi @Anonymous ,
If you can use custom visuals, you can develop this visual in https://pbivizedit.com
I am able to produce following visual by the data you have give:
Please try and feel free to contact their support if you find it difficult to reproduce this visual.
Thanks,
-R
Hi @Anonymous ,
If you can use custom visuals, you can develop this visual in https://pbivizedit.com
I am able to produce following visual by the data you have give:
Please try and feel free to contact their support if you find it difficult to reproduce this visual.
Thanks,
-R
Thanks for the advice, let me try and I'll accept your solution later.
@Anonymous , You can have three lines two lines can be the constant measure
upper =210
lower =90
Enable label only for one line and bar
The problem is that I can't get the red lines to use the values of the left Y-axis they use the right one, the secondary axis that is used by default. And the lines values vary depending on the filtered data so I can't make them constant.
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 |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |