Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Dear All,
I have date column as part of the Page filter and not slicers
Users can select a single month in the filter pane; for example 2020-03
I have a bar chart visual which should display last 12 months from the selected Month ( In this case April'19 to Mar'20)
Because of the page level filter bar chart was showing only March 2020
Used ALL in the filter then i can get all the months in the database ( In this case Jan'19 to May'20)
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
As suggested, i tried the same. But it is not working.
I am also having the same issue. Can you please suggest if it is working for you.
This is not working for me
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
User | Count |
---|---|
47 | |
26 | |
21 | |
17 | |
15 |
User | Count |
---|---|
53 | |
34 | |
17 | |
17 | |
15 |