Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
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/
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 55 | |
| 40 | |
| 35 | |
| 19 | |
| 18 |
| User | Count |
|---|---|
| 71 | |
| 70 | |
| 38 | |
| 35 | |
| 23 |