One Button Multiple Bookmarks

[manasengineer]

Hi Everyone, 

I have a project slicer, when I choose one, the stage table gets filtered, telling me at what stage the project is. Now I have a button which I want to program such that, when clicked it only shows me the visuals specific to that stage. So if the stage table is filtered showing project is at stage A, only visuals on stage A appear upon clicking the button. Is there a better way to do this, only what kind of DAX can be implemented here.

Thank you so much (in advance) for your help and ideas.

[manasengineer]

Exaclty, it is a partial bookamrk, so the bookmark button responds in such a way -

 IF project stage = 2, then show Stage 2 visuals, else, empty screen

[amitchandak]

@manasengineer , one you select the project, based on current project select your stage can be

maxx(allselected(Table), Table[Stage])

Now you can use that as a filter in another measure and that will restrict the visual on stage A (As project A filtered it will project A, Stage)

In case you need latest stage only

Latest
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0

https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee8...

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[manasengineer]

Hi @amitchandak, so the issue persists. 

Here is what I am trying to do, 

1. I have a project slicer, in which when I select a project a bunch of visuals get filtered.

2. Out of which there is one visual, a table (with 4 entries) that tells project stage

3. When the project is selected from the slicer, the stage table gets filtered to the current stage of the project

4. Next to the project stage visual, is a button titled current stage details

5. When I click this button, I want that it sees the filtered value in the project stage table and show only the visuals corresponding to that stage.

Example,

1. I select project A

2. Project A is in stage 2, thus, project stage table only shows me one value, which is the number 2

3. I click on the current stage details button, visuals that are specific to stage 2 should pop up in the same page.

Hope this helps clarify my question.

[amitchandak · Accepted solution]

@manasengineer , What I got when You select stage two and press the button then the project filter should go away?

I was thinking of using the bookmark button but passing the partial slicer value will be a challenge.