Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

Dynamic Top N Dashboard with Analysis Services Connection

Hello,

 

I am looking to do something like what is shown in the below video (creating a toggle to select which Top N to show), but my data set is a Live Connection to Analysis Services. As such, I don't have the ability to add tables (and my IT team owns the underlying data and is reluctant to add things on the backend). Is there another way to do this / a workaround for when you are linked up to Analysis Services?

 

https://www.youtube.com/watch?v=JUgROZURmrs

 

Thank you!

Hannah

1 ACCEPTED SOLUTION

 

Hi @Anonymous ,

 

Yes, if you use connect live mode ,there is no way to dynamically change the top N currently.

 

While you may post your new idea here https://ideas.powerbi.com/forums/265200-power-bi-ideas , to improve the Power BI.

 

It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

3 REPLIES 3
v-xicai
Community Support
Community Support

Hi @Anonymous ,

 

When you connect to SSAS using connect live mode, it is not supported to create new table and calculated column, while you can only create report level measures for SSAS Tabular Model in Power BI Desktop . However it still can't achieve your demand of dynamic top N selection filter.

 

So recommend you using Import mode instead of connect live mode when connect to SSAS in your scenario.

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Thank you, Amy! That's helpful. My organization requires live connection because they don't want people manipulating the underlying data in any reports (so there is one source of truth) and so that data updates are pushed in automatically. If this is the case, then there is no way to dynamically change the N seen, correct?

 

Thanks for your help!

 

Hi @Anonymous ,

 

Yes, if you use connect live mode ,there is no way to dynamically change the top N currently.

 

While you may post your new idea here https://ideas.powerbi.com/forums/265200-power-bi-ideas , to improve the Power BI.

 

It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.