Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I searched exhaustively, but did not manage to find an answer, hence, I hope I'm not repeating a question here.
Situation:
I have my report with multiple visualizations and matrix tables. Example below: I set all my interactions and they work as they should be. However, this one part appears not to work.
If I select my month bar (1), this filters out my matrix table on the right correctly. So far so good.
But when I try drill down (2) on any of the items in my now-filtered matrix table, my month gets unselected (filter is removed).
This does not happen with the Show Next Level and Expand to Next Level functions though. Only with the 'Drill-down' option.
Any suggestions?
Thanks
Ged
Hi @Ged,
The fix will be released around 10/12/2017.
Best Regards,
Qiuyun Yu
Thanks for this. Just a recheck? 10/12/2017 you meant dd/mm or mm/dd? As I already received questions from my business users re this functionality.
Furthermore, I think it can be bucketed under the same question. Let us say this is re 'interactivce inter-filtering across numerous sections'
Situation:
I currently present my summarised P&L accounts. The user is able to isolate their month (1) which in turn filters out the product and location dimensions. So far so good.
However, what I want to do together:
1. To be able to select my month (all good).
2. Then select my biggest variance contribut in my now-filtered product matrix WITHOUT LOSING my previous month selection (my primary month selection is lost here if I click on anything in my product matrix).
3. This, subsequently, should filter out my location matrix futher for that particular month and that particular product.
I understand that it can get ambigous - what filters out what in which case, but I see that is a lack of functionality. This would IMMEDIATELY cut down on the time spent doing our var analyses.
Thanks
Ged
Hi @Ged,
I have reported this issue internally. Will update here once I get any information.
Best Regards,
Qiuyun Yu
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
75 | |
63 | |
51 | |
48 |
User | Count |
---|---|
204 | |
86 | |
64 | |
59 | |
56 |