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 community,
Could you please share some ideas on how to handle the 'Version Date' filter? The default setting for the report should display the latest version date, but we also want to provide users with flexibility to choose the version dates they need. We are considering an option to allow users to view the latest version date by selecting 'Yes,' while still providing the ability for users to manually choose their desired version date.
Your insights and suggestions are greatly appreciated!
Solved! Go to Solution.
Hi @Julia_Mav ,
I am not sure if I understood your question correctly.
Based on my understanding, I created some data:
1. You can create a calcualted table.
Table 2 = DATATABLE("Whether to view the latest version date",STRING,
{{"Yes"}, {"No"}}
)
2. Use the following code to create a Measure.
Measure =
VAR Toggle = SELECTEDVALUE('Table 2'[Whether to view the latest version date])
VAR Temp = IF(Toggle = "Yes",1,0)
RETURN
IF(Temp = 1,
IF(SELECTEDVALUE('Table'[Version Date]) = TODAY(),1,0),
1)
3. Select your visual object, put the measure in the “Filters on this visual” section, and filter it by “Measure is 1”.
The field of the slicer is from Table 2. When you select "Yes" in the slicer, Result is as below.
To allow users to manually select the desired version date, you can create another slicer, Result is as below.
Please correct me if I misunderstood your needs.
Best Regards,
Yulia Yan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Julia_Mav ,
I am not sure if I understood your question correctly.
Based on my understanding, I created some data:
1. You can create a calcualted table.
Table 2 = DATATABLE("Whether to view the latest version date",STRING,
{{"Yes"}, {"No"}}
)
2. Use the following code to create a Measure.
Measure =
VAR Toggle = SELECTEDVALUE('Table 2'[Whether to view the latest version date])
VAR Temp = IF(Toggle = "Yes",1,0)
RETURN
IF(Temp = 1,
IF(SELECTEDVALUE('Table'[Version Date]) = TODAY(),1,0),
1)
3. Select your visual object, put the measure in the “Filters on this visual” section, and filter it by “Measure is 1”.
The field of the slicer is from Table 2. When you select "Yes" in the slicer, Result is as below.
To allow users to manually select the desired version date, you can create another slicer, Result is as below.
Please correct me if I misunderstood your needs.
Best Regards,
Yulia Yan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Julia_Mav
Please check if this video can help you resolve your issue: https://youtu.be/KBEsPGxDxHM
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.