Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi @FunWithPowerBI ,
Create to unrelated tables for the slicer 1 and slicer 2 then add the following measure:
Filter_By_Slicers =
VAR Star_date =
MIN ( 'Dates Slicer'[Date] )
VAR end_date =
MAX ( 'Dates Slicer'[Date] )
VAR Slicer_2 =
SELECTEDVALUE ( 'Slicer 2'[ID] )
RETURN
SWITCH (
TRUE ();
Slicer_2 = 1
&& SELECTEDVALUE ( Data[Date] ) >= Star_date
&& SELECTEDVALUE ( Data[Date] ) <= end_date; 1;
Slicer_2 = 2
&& SELECTEDVALUE ( Data[Status] ) = "Active"
&& SELECTEDVALUE ( Data[Date] ) <= end_date; 1;
Slicer_2 = 3
&& SELECTEDVALUE ( Data[Status] ) = "Active"
&& SELECTEDVALUE ( Data[Date] ) <= Star_date; 1;
BLANK ()
)
Now filter you visualizations by all values that are not blank.
Check PBIX file attach.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @FunWithPowerBI ,
Create to unrelated tables for the slicer 1 and slicer 2 then add the following measure:
Filter_By_Slicers =
VAR Star_date =
MIN ( 'Dates Slicer'[Date] )
VAR end_date =
MAX ( 'Dates Slicer'[Date] )
VAR Slicer_2 =
SELECTEDVALUE ( 'Slicer 2'[ID] )
RETURN
SWITCH (
TRUE ();
Slicer_2 = 1
&& SELECTEDVALUE ( Data[Date] ) >= Star_date
&& SELECTEDVALUE ( Data[Date] ) <= end_date; 1;
Slicer_2 = 2
&& SELECTEDVALUE ( Data[Status] ) = "Active"
&& SELECTEDVALUE ( Data[Date] ) <= end_date; 1;
Slicer_2 = 3
&& SELECTEDVALUE ( Data[Status] ) = "Active"
&& SELECTEDVALUE ( Data[Date] ) <= Star_date; 1;
BLANK ()
)
Now filter you visualizations by all values that are not blank.
Check PBIX file attach.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsJoin the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
89 | |
79 | |
70 | |
69 |
User | Count |
---|---|
226 | |
129 | |
119 | |
84 | |
77 |