Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I have a requirement as below:
I have two cards ,1. Balance Available 2. Ending Balance which are two measures. Both these cards should dynamically hide and show the measures based on "Category" field shown below. (that is when BSF category is selected the card should show Ending balance measure and when "UI" is selected , it should show Balance Available measure
Note: There are no slicers for Category. Based on the user access/other slicers available in the report, the category column gets filtered in the report.
Can someone let me know how this can be achieved?
Thanks
Poojitha
Solved! Go to Solution.
Please see if this would help :
The card is mapped to a measure :
Probably you are missing a relationship between the tables in model.
Hello!
isn't this feasible with a measure on selected value for Category for you? The Label will default to the selected Value with no need to hide/unhide
Am I missing something here?
Hi @AbhiSSRS
Please note that there is not slicer for the "Category" field, this field is getting filtered based on the other slicers available.
Is there a way to achieve this? As there are two measures to be shown dynamically.
It would still work! the selected value for the control which shows 'Category' will automatically show up the corresponding value on the card visual. Like when BSF is selected(based on other selections as you mentioned) it would display Ending Balance in the Card.
@AbhiSSRS
Tried to replicate the same but could not achieve, below is the sample data.
Is possible, can you suggest the solution with the data given here?
Please see if this would help :
The card is mapped to a measure :
@AbhiSSRS
Can you please confirm if you are using single card? If yes, pls do let me know how the titles are being changed dynamically
Yes this is a single card mapped to the measure. The measure changes its value dynamically so it appears as per requirement. This may be an alternative to your actual requirement of having 2 and hiding/unhiding because that is not feasible without button clicks (bookmarks need button clicks)
Map the Title text to field , it will change dynamically based on selection
@AbhiSSRS Tried to do the same but the text is showing as balance available always though i selected a category which has ending balance( but the numbers are changing correctly.)
Probably you are missing a relationship between the tables in model.
Hi @Anonymous
You can achieve that by using
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi @Anonymous
Maybe this video can help you better
https://www.youtube.com/watch?v=xCMqWEvSkAs
Or maybe A sample Pibx would help me show you through your model
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi @aj1973
Thanks for the video. I have understood the concept of bookmarks, but trying to understand how the bookmarks can be used the achieve my scenario where i need to show either the Ending Balance or Balance Available based on the values that are available in the category field.
Probably , could you share a pbix file if possible and that will help.
thank you.
Hi @Anonymous
Here is a report where i used bookmarks and drillthroughs to navigate between pages and visuals
(Sorry can't share the Pbix though)
Maybe if you can share a sample of your Pbix then i can I help you with it.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
@aj1973
Tried to attach the pbix file but it doesnt allow,
https://app.powerbi.com/view?r=eyJrIjoiMGVhZDgwN2MtMmU2NC00ZTY1LTg3MDktNzQ5Nzg5ZjZjOTU4IiwidCI6ImY3M...
Can you help with the solution based on the screenshots?
Hi @Anonymous
You need to upload it to a cloud storage to share publicly your Pibx file like Google Drive, One drive....
Please do!
Are these descriptions of the category fixed or variables?
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
@aj1973
I am trying to have the file upload onto the drive , will share it across.
From the above image you sent, those are the measures which needs to be shown for a given "Category" value.
Eg: BSF should show the "Ending balance" measure in the card and hide the "Balance available" card.
"Ending balance" and "Balance available" are measures
User | Count |
---|---|
65 | |
27 | |
25 | |
17 | |
11 |