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.
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.
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 |
---|---|
106 | |
104 | |
79 | |
68 | |
61 |
User | Count |
---|---|
144 | |
104 | |
103 | |
82 | |
70 |