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
meg5w
Frequent Visitor

Graph filter for OVERALL total not column total

I am needing to filter a graph, basically saying if the total count is <4, don't show the graph. I tried adding this to the visual level filters but did not have any luck, as it breaks it down and filters the colum totals - not the OVERALL total. Is there a way to do this? 

1 ACCEPTED SOLUTION
v-yuta-msft
Community Support
Community Support

@meg5w ,

 


@meg5w wrote:

I am needing to filter a graph, basically saying if the total count is <4, don't show the graph. I tried adding this to the visual level filters but did not have any luck, as it breaks it down and filters the colum totals - not the OVERALL total. Is there a way to do this? 


I'm afraid slicer/visual level filter can only filter the rows in table, they can't remove a visual based on user's selection. As a workaround, you may create several bookmarks and several buttons(which present different sitution. e.g.: Total < 4, Total = 4, Total > 4) and select one bookmark as action for each button.

 

About how to create bookmarks and link to button, please refer to doc below:

https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks

https://docs.microsoft.com/en-us/power-bi/desktop-buttons#select-the-action-for-a-button

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yuta-msft
Community Support
Community Support

@meg5w ,

 


@meg5w wrote:

I am needing to filter a graph, basically saying if the total count is <4, don't show the graph. I tried adding this to the visual level filters but did not have any luck, as it breaks it down and filters the colum totals - not the OVERALL total. Is there a way to do this? 


I'm afraid slicer/visual level filter can only filter the rows in table, they can't remove a visual based on user's selection. As a workaround, you may create several bookmarks and several buttons(which present different sitution. e.g.: Total < 4, Total = 4, Total > 4) and select one bookmark as action for each button.

 

About how to create bookmarks and link to button, please refer to doc below:

https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks

https://docs.microsoft.com/en-us/power-bi/desktop-buttons#select-the-action-for-a-button

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Please [ost sample data, expected a result and error you are facing.

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.