Reply
Regular Visitor
Posts: 22
Registered: ‎02-10-2018
Accepted Solution

FIltering a Table with slicer

Hello!

 

I'm having a problem trying to solve a filtering issue.

 

I've a slicer that I want to filter the table you can see below:

 

filter.JPG

 

But it doesn´t. Which kind o filter I should change. I was reading the microsoft documentation but I have not found the solution

 

The project is in this link: https://files.fm/u/fcnwjsms


Accepted Solutions
Highlighted
New Contributor
Posts: 420
Registered: ‎04-14-2018

Re: FIltering a Table with slicer

@joaco

 

When you say filter do you mean, not to display the rows where all cells are blank?

 

If this is the case you can do the following.

Create a new measure with the sum of all the measures from the table:

Row_Filter = SUM(Fact_Table[Atencion_Acumulado])+SUM(Fact_Table[Atencion_Anual])+SUM(Fact_Table[Tiempo_Acumulado])+SUM(Fact_Table[Tiempo_Anual])

Then add this to the table filter to hide these rows,

 

Workspace attached

View solution in original post


All Replies
Super User
Posts: 10,536
Registered: ‎07-11-2015

Re: FIltering a Table with slicer

Would need to understand your source date. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Highlighted
New Contributor
Posts: 420
Registered: ‎04-14-2018

Re: FIltering a Table with slicer

@joaco

 

When you say filter do you mean, not to display the rows where all cells are blank?

 

If this is the case you can do the following.

Create a new measure with the sum of all the measures from the table:

Row_Filter = SUM(Fact_Table[Atencion_Acumulado])+SUM(Fact_Table[Atencion_Anual])+SUM(Fact_Table[Tiempo_Acumulado])+SUM(Fact_Table[Tiempo_Anual])

Then add this to the table filter to hide these rows,

 

Workspace attached