Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a bar chart that is currently being filtered. when the chart is filtered the X axis values change How can I keep the axis value consistant regardless of which item in the slicer is selected? In the example below the x axis shows dates for July 27 - Aug 3. This is what I want. In the second example this filtered item has no activity yet and it shows dates Aug 02, Aug 09, Aug 23,Aug, Aug 30.
I want the dates on the second example to match up with the dates from the first examples
Slicer 1
Slicer 2
Solved! Go to Solution.
One quick thing to try would be to put "+0" on the end of your measure, so it always returns a result (and won't get filtered out by the visual as it won't be blank). This may make other x axis values show up depending on your model, but it's a quick thing to try.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@dw700d , Add +0 to the measure.
or check if interactions can help
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
One quick thing to try would be to put "+0" on the end of your measure, so it always returns a result (and won't get filtered out by the visual as it won't be blank). This may make other x axis values show up depending on your model, but it's a quick thing to try.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.