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 everybody,
When trying to delete hierarchy date filtering with ALLSELECTED in a matrix with date(rows) and Countries(columns), first hierarchy level (year) works well but the other (quarter, month, day) don't delete their filter although using multiple columns in ALLSELECTED. How could I solve it? Thanks a lot for your help !!!.
(Figures not in bold should match the total column ones)
Solved! Go to Solution.
@Syndicate_Admin
You need to also add the columns [MonthNo] and [QuarterNo]
(Alltough you don't see them in the visual they are used in the query that creates it in order for the months and quarters to be sorted correctly)
@Syndicate_Admin
You need to also add the columns [MonthNo] and [QuarterNo]
(Alltough you don't see them in the visual they are used in the query that creates it in order for the months and quarters to be sorted correctly)
Thanks a lot, I was convinced it should be easy but don't found it. You helped me.
You are welcome. My pleasure.
Could you please mark this as a solution 🙂
Thank you
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 |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |