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 everyone,
I am trying to show the selected filter (for e.g. year of selected date filter) on my report to keep it dynamic.
I know it is possible to do that with DAX but this is not an option with using live connection to multidimensional SSAS.
Is there any workaround for users with live connection or we are doomed to use only static labels in our report?
Any help would be appreciated.
Hi Reza,
Yes, with live connection to Multidimension Model you can't create any measure so I'm afraid you can't achieve selected values and apply these values as condition in your measure.
However, if you can change Multidimension Model to Tabular Model, you can create measures when using live connection to Tabular Model.
Regards,
Jimmy Tao
Hi @v-yuta-msft,
Thanks for your suggestion but unfortunately that is not an option for us.
We use many to many relations in our cube which is not supported in tabular model (The bi-directional cross filtering in tabular model is not actual many to many table configuration).
There is also limitation on multiple relationship between fact tables and date table (There are workaround but are not elegant at all).
So I think Microsoft has to either introduce a solution for Multidimensional SSAS users or just stop live connection for that as with these limitations there is no point using that.
Thanks
Hi Reza,
Thank you very much for your suggestions, I would recommend you to submit your idea here: https://ideas.powerbi.com so that the product team can take consideration on this feature.
Regards,
Jimmy Tao
Hi @v-yuta-msft
It is already added in ideas
More than a year ago with 1100+ vote and no words from them.
FRUSTRATING if anyone from Power BI team reading this!
Hi Reza,
Do you have a pro account? If you have, you can create a support ticket here: https://powerbi.microsoft.com/en-us/support/ so that your issue can be responsed to power bi team(PG) straightly.
Best Regards,
Jimmy Tao
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |