Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
Hi.
I am trying to create a group of line charts using small multiples. I would like each graph to have a separate y-axis, so that the lines on each graph are more easily discernable/not smushed together since the first two graphs have much wider y-axis ranges.
I realize that I could create six separate visuals, but I would lose the ability to view all of them at once in focus mode. Additionally, the space that I need to fit this in is rather small, so the formatting with legends/titles starts to look bad.
I found a few threads on this website that indicated that I can turn off the Shared Y-Axis option. However, I cannot find this option. From the screenshots and youtube video I found mentioning this option, it should be right below Invert Range. See the screenshot below for the y-axis options that are available to me.
This is what I'm expecting to see ->
Was this feature removed?
Solved! Go to Solution.
Hi @Jrob1765
The functionality is available :
I can't know why it isn't working for you without access to your pbix, but I attached the pbix with an example, you can follow my steps.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi @Jrob1765 ,
Your solution is great, @Ritaf1983. It worked like a charm! Here I have another idea in mind, and I would like to share it for reference.
If you want to use Shared y-axis, I think your Small multiples under Visual are required to put values.
That way when you select Y-axis it will show Shared y-axis.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Jrob1765
The functionality is available :
I can't know why it isn't working for you without access to your pbix, but I attached the pbix with an example, you can follow my steps.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
User | Count |
---|---|
77 | |
70 | |
68 | |
53 | |
48 |
User | Count |
---|---|
45 | |
38 | |
35 | |
31 | |
28 |