Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear All,
I have one query in PowerBIDesktop, actually, we did one report that contains ne Pie chart which represents the data of "states literacy details with respective populations" for example pie chart has shows data for five states.
And I have one slicer on which we can choose the five states to see the literacy details of states respectively.
But my requirement is to show only one state detail as a default in the pie chart after clearing the slicer filters.
Request you to please suggest me how to achieve this solution.
Thank you in advance.
With best regards,
Karthik A.
Solved! Go to Solution.
Hi @karthik0507 ,
In that case if you want to create a button to reset the slicer then you can use a bookmark to get that functionality.
https://hatfullofdata.blog/power-bi-resetting-slicers-with-a-bookmark-button/
For showing the default selected state you can still save the report with the default selection.
Please accept this as a solution if your question has been answered !!
Appreciate a Kudos 😀
Connect with me on LinkedIn: https://www.linkedin.com/in/jaideepnema/
Thank you for your valuable time.
use visual level filter,by default it will show the selected state
Hi @karthik0507 ,
I am not very clear but did you tried selecting that specific state and saving the report with that default selection. Let me know if this helps.
Please accept this as a solution if your question has been answered !!
Appreciate a Kudos 😀
Connect with me on LinkedIn: https://www.linkedin.com/in/jaideepnema/
Hi Jaideep,
Thank you for your response, actually, I tried in that manner also but my requirement is not exactly a similar case.
I have one more button with "Clear all filter" action. when some one select that button my pie chart should show predefined state details.
Please let me know is there any possibilities.
Thank you in advance, once again.
Hi @karthik0507 ,
In that case if you want to create a button to reset the slicer then you can use a bookmark to get that functionality.
https://hatfullofdata.blog/power-bi-resetting-slicers-with-a-bookmark-button/
For showing the default selected state you can still save the report with the default selection.
Please accept this as a solution if your question has been answered !!
Appreciate a Kudos 😀
Connect with me on LinkedIn: https://www.linkedin.com/in/jaideepnema/
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |