Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
100 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |