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 All, Thank you for Jumping in to assist on this.
We have a bar chart generated with X and Y axis.
The running numbers for Y axis is generated by using Groupby. It means, we have values from 1 till 42 and the Grouping Bin value is set as "5" and so the Y axis runs as 0, 10, 15, 20, 25.......as dynamic data.
The requirement here is that there are some Y axis values such as 20, 35 where the corresponding X axis data is not present and it appears as blank. In this case we dont want 20 and 35 to be displayed in the Y axis and the series should be 0,10,15,25,30,40.....
We tried with Advanced Filter as "Ignore blank" and all options. But couldn't restrict it.
Do we have an inbuit feature or should we do a workaround?
Thank you.
Solved! Go to Solution.
Hi @smibrahim,
Please change the Y-axis type from "Continuous" to "Categorical".
Best regards,
Yuliana Gu
Hello Yuliana,
Hurray!!! It helped. Thank you very much 🙂
Best Regards,
Siraj
Hi @smibrahim,
Please change the Y-axis type from "Continuous" to "Categorical".
Best regards,
Yuliana Gu
Hello Yuliana,
Hurray!!! It helped. Thank you very much 🙂
Best Regards,
Siraj
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 |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |