March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hello All,
I need a help.
Is there any way in which i can store values passed in url in a parameter and use it later.
Why do i need this?
Problem Statement:
My user wants to have a dashboard which will contain
Level 1: Some image tiles (for example Project 1,Project 2,etc...), after clickling on any one image it should get redirect itself
to Level 2 which contains
Level 2: categories (Now this categories are same for all the projects e.g Expernse, Quality, etc ) after clicking on any category button it should get redirect to Level 3
Level 3: Actual Reort with Slicer value (Slicer will contain Project 1 or Project 2 as its value, depending what user was selected)
How I achieved this is:
I created Dashboard with Project 1, Project 2, etc as image tiles. On clik of any one of them i set a custom external link of another dashboard which is categories dashboard and here on clickling any category i passed url to actual report.
The challenge which i am facing at Level 2 is how will i be able to know whether user has selected Project 1 or Project 2 or Project 3, as the categories will be same for all the projects and i want to keep only one categories dashboard.
So there any way that i can store values in a parameter and pass it furthur to any level.
Kindly help me in this,
Please suggest me any other better approach for doing this.
Does my reply slove your problem?
If not, please let me know.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Per your requirement, i would suggest you to consider using "drillthrough" and bookmark features.
Refernce documents:
They are both able in Power BI Desktop and Service.
When you create a report using Power BI Desktop, then you could publish it to Power BI Service.
However, i need to know your data structure so i can give a clear and sufficent solution.
I make a simple example with my supposed data.
Page1->Level1, Page2->Level2, Page3->Level3,
Add "project" in the "drill through" filter field on the Page2, Add "project" and "categories" in the "drill through" filter field on the Page3.
Page1
Page2
Page3
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
40 | |
26 | |
17 | |
11 | |
10 |
User | Count |
---|---|
58 | |
52 | |
23 | |
14 | |
11 |