Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi Fabric Community,
I'm currently working on a Power BI report using a live connection to a semantic model. My challenge is to implement dynamic slicers without switching to a mixed model, which creates a new semantic model that I want to avoid.
Here's the scenario:
I have separate dimension and fact tables in my source.
I need end-users to have the flexibility to choose different dimensions and measures dynamically (similar to the field parameters feature in Power BI).
I'm looking for solutions or workarounds that would allow this flexibility while keeping the live connection intact and avoiding the need for a mixed model. Are there any custom slicers, visuals, or other approaches that could help achieve this?
Thank you in advance for your assistance!
Solved! Go to Solution.
Hi @uma91 ,
I would create this Field Parameters in the original Semantic Model, in order to use it on your report otherwise and to my knowledge you will always need to have the composite model.
One option that you can try the personalize visuals options.
This option can be given at several levels, full report, a page or a specific visual
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @uma91 ,
I would create this Field Parameters in the original Semantic Model, in order to use it on your report otherwise and to my knowledge you will always need to have the composite model.
One option that you can try the personalize visuals options.
This option can be given at several levels, full report, a page or a specific visual
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
66 | |
60 | |
47 | |
33 | |
32 |
User | Count |
---|---|
86 | |
75 | |
56 | |
50 | |
45 |