Using the slizer to show only the ones where specific columns have Data.

[JDG]

Hello, 

i made for my Projekts custom columns for 6 Situations, where i look how long it took from: data received to: related work finished (with DATEDIF). I can show this data easaly with Diagrams. So then i wanted to make a slicer to only show one of the 6 Situatuions. But i cant do it.

The problem is that the projekts i look at can have one up to all 6 Situations at the same time. But i only want to show the data of one aspekt of it.  

For example Projekt 1 has  Situations A;B;C and projekt 2 has Situations B;D. I dont need to see the Projekts. So i want a slizer with the informations related to A;B;C;D;E;F. 

So every Row of a Projekt as every column of the DATEDIFF related to A;B;C;D;E;F but only the ones with available data are filled. For example Projekt 1 that has  DATEDIFF A;B;Cn is empty for the columns DATEDIFF D;E;F.

How can i make a slicer that only shows the projekts where there is data in a specific column. For example DATEDIFF A.

I hope my explanation is understandable.

Have a great Day and thanks in advance.

[v-rzhou-msft · Accepted solution]

Hi @JDG ,

Do you want to show the projects contain the selected situation in slicer? Here I suggest you to create an unrelated dimsituation table for slicer and then create a measure.

My Sample:

Dimsituation:

Selection = 
{"A","B","C","D","E","F"}

Measure:

Measure = 
VAR _SELECTVALUE = SELECTEDVALUE(Selection[Value])
VAR _PROJECT_LIST = CALCULATETABLE(VALUES(Data[Situation]),ALLEXCEPT(Data,Data[Project]))
RETURN
IF(_SELECTVALUE IN _PROJECT_LIST,1,0)

Add this measure into the visual level filter of table visual and set the measure to show items when value =1.

Result is as below.

Best Regards,
Rico Zhou

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