Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
In this screenshot i used relative filter to show next six months of datas. In that i want to show no data in a month also so i give no data enable also..this Tile shown correctly but the issue is i dont want to see the previous Month names in X axis i want to see today to next 6 month only......Any help is from anybody is always welcome..
Solved! Go to Solution.
Hi @Anonymous ,
Can you try moving Year along with Month on your x-axis?
Then when you apply relative date filtering, it will filter x-axis also.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
hi,
I already tried with that kind of method by year along with Month on x-axis
but it didnt give accurately..
Hi @Anonymous ,
Looking at your screenshot, the chart looks right with correct MONTH-YEAR values on x-axis, based on the selection you have made in relative date filter.
You are seleceting NEXT 6 MONTHS from TODAY: this should June 2020 to November 2020. This is what is shown on your chart.
What you are thinking it is wrong?
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Hi @Anonymous ,
Can you try moving Year along with Month on your x-axis?
Then when you apply relative date filtering, it will filter x-axis also.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
hi,
I already tried with that kind of method by year along with Month on x-axis
but it didnt give accurately..
Hi @Anonymous ,
Looking at your screenshot, the chart looks right with correct MONTH-YEAR values on x-axis, based on the selection you have made in relative date filter.
You are seleceting NEXT 6 MONTHS from TODAY: this should June 2020 to November 2020. This is what is shown on your chart.
What you are thinking it is wrong?
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
@Anonymous , Couple of reasons
1. Your formula has used +0
2. Your filter on the date and date on-axis is different
User | Count |
---|---|
101 | |
90 | |
79 | |
70 | |
70 |
User | Count |
---|---|
112 | |
96 | |
96 | |
75 | |
72 |