Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |