Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi All,
I am in the current scenario:
That's all fine so far.
Then, I created a bookmark for each of the possible 4 selections:
The slicer has been hidden in each bookmark.
Then, I created 4 buttons and each button corresponds to each bookmark. When I click the button, the corresponding selection is displayed.
What I would like to do is to display in a card the selected value, to understand whether I am in Region 1, Region 2, Region 3 or all of them. So, for example, when Region 1 button is clicked, the card will display something like "Region 1"
I followed this tutorial and came up with the following measure, but it does not work
SelectedRegion = IF( ISFILTERED(WWTickets[TkServerName]), SELECTEDVALUE(WWTickets[TkServerName], CONCATENATEX( ALLSELECTED(WWTickets[TkServerName]), WWTickets[TkServerName], ", " ) ), "No Selection")
where WWTickets[TkServerName] is the field assigned to the main slicer.
Any clue, please?
Solved! Go to Solution.
Please ignore.
The measure in the first post works well. I was in PBI Desktop, where CTRL+ Click is required and I was only clicking on the buttons, I guess I need another coffee
Here is how I did something similar
Please ignore.
The measure in the first post works well. I was in PBI Desktop, where CTRL+ Click is required and I was only clicking on the buttons, I guess I need another coffee
HI, @EVEAdmin
I have test on my side with your formula, it works well too.
and for power bi desktop is a "development tool" , it has some difference when interacte on the report, you need CTRL+ Click for selected button.
And It's pleasant that your problem has been solved, please accept the reply as a solution, that way, other community members will easily find the solution when they get same issue.
Thanks.
Best Regards,
Lin
@v-lili6-msft thank you.
I was fully aware of the CTRL+Click, simply forgotten
Marked my reply as solution, tnx again.
I can establish a relation between the card and the value selected in the slicer.
It seems the issue is with the buttons. Each button is associated with a bookmark.
So, is there anything I can do to display a button title, or other field, in a card ?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
97 | |
65 | |
45 | |
39 | |
31 |
User | Count |
---|---|
164 | |
111 | |
61 | |
53 | |
38 |