Forum Discussion
Super UserBookmarks - New Scenario
Hello Power BI Experts:
I am trying to implement Bookmarks in Power BI in a different scenario and not able to get a satisfied solution.
I have 2 tabs on my dashboard.
1st tab has 9 multi-card visuals. In individual multi-card visual there are few metrics shown as below:
I have 9 such multi-cards on this same tab with different visual-level filters.
2nd tab is a detailed view for individual multi-card as on 1st tab, with some additional information.
Now my task here is to create a link from Multi-card (as shown above may be a icon) on 1st tab to the detailed 2nd tab taking along the visual level filters to the detailed tab. This link is required for each of the 9 multi-cards on 1st tab which have different visual level filters.
Now the challenge here is linking every multi-card from 1st tab to the 2nd tab with different visual filters.
I know a way of doing it by creating 9 individual detailed tabs for each of the 9 multi-card visuals with the required visual level filters and setting up the bookmarks for navigation.
But, I am looking for a solution if the above navigation is possible on a single detailed tab rather than creating 9 different detailed tabs. This will just avoid creating multiple detailed tabs for respective 9 multi-cards.
Does a solution sit around this scenario?
Let me know if further details are required.
Thanks in advance,
Pragati
You could also do something like this where you use the treemap visual with your category and one of the values in it. Then you filter each tree map to a single selection and use it as a header. When you click on one of the "headers" the model reads it as a category selection and enables the drillthrough.
No selection, drill through disabledMedical "Title" (tree map visual) is selected the drillthrough is enabled.
4 Replies
- jdbuchanan71
Hi Pragati11
I am guessing that there is a category of data (country, region, brand) and each of the cards is filtered to one value? The only way I can think to do it would be by adding a matrix with those values where a user could select one of them and have a drillthrough button that carries the selected value to your detail page.
In my example I am using [Plan Type] as the filter on the card.
I also have a matrix with the [Plan Type] on the columns.
My 2nd page is detail page with [Plan Type] as the drillthrough filter.
I have added a button with an action of drillthgouh and a target of page 2.
You can see when I have no column selected in the matrix the drillthrough button is disabled.
But when I click on a single [Plan Type] column in the matrix the drillthrough button is enabled and I can click it to go to my detailed drillthrough page and bring the [Plan Type] filter from my selection.
That is the best I can come up with for your scenario. The matrix give you a place to select the category value you want to see detail on. I also edited the interactions so my matrix does not filter the cards. Othwise a selection in the matrix would turn off all the cards except the one you clicked on.
- jdbuchanan71
You could also do something like this where you use the treemap visual with your category and one of the values in it. Then you filter each tree map to a single selection and use it as a header. When you click on one of the "headers" the model reads it as a category selection and enables the drillthrough.
No selection, drill through disabledMedical "Title" (tree map visual) is selected the drillthrough is enabled.
- Pragati11
HI jdbuchanan71 ,
Thank you so much for responding back.
The 1st solution of your is not an option for me as I can't show my visual filter as a matrix.
Give me sometime I will check the 2nd solution suggested by you. 🙂
Thanks,
Pragati
