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.
Hi all,
I want to count id by month but only on the last 12 months.
I added a relative date filter on the visual but it does not change the output.
To be more specific, I would like that my x axis contains all the months from november 2019 to november 2020, even if the count is 0
for more details, the pbix is available here
thanks for your help!
Solved! Go to Solution.
Check the attached file.
You need to disconnect the date table from your data table.
Check the attached file.
You need to disconnect the date table from your data table.
@toto1303 , Not very clear. Add +0 to the measure
thank for you answer,
actually, the problem is on the x axis. as you can see on the image, the months goes from january 2019 to december 2020 but I only want to see the last 12 months ie from november 2019 to november 2020
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
50 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |