Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
karthik0507
Frequent Visitor

default pie chart value setting

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.

1 ACCEPTED 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/

View solution in original post

5 REPLIES 5
karthik0507
Frequent Visitor

Thank you for your valuable time.

kollasv
Helper I
Helper I

use visual level filter,by default it will show the selected state

jaideepnema
Solution Sage
Solution Sage

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/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.