Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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