Forum Discussion

lavankumar1989a's avatar
lavankumar1989a
Helper II
5 years ago
Solved

Assistance on DAX

Hi Experts,   Greetings for the day and hope all are doing good! Need your kind assistance on achiving my requirements. i have date column and when user selected a perticular date in page 1, user ...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    5 years ago

    Hi lavankumar1989a ,

     

    If you want to filter multiple visuals in this way, I think it is more convenient to create a direct correspondence between the date of the slicer and the date to be filtered. Try the following cade in Power Query:

     

    let
    Source = Table.FromValue(#"Table"[Date], [DefaultColumnName = "Slicer_Date"]),
    #"Removed Duplicates" = Table.Distinct(Source),
    #"Added Custom" = Table.AddColumn(#"Removed Duplicates", "Table_Date", each List.Dates([Slicer_Date],7,#duration(1,0,0,0))),
    #"Expanded Custom" = Table.ExpandListColumn(#"Added Custom", "Table_Date")
in
    #"Expanded Custom"

     

    Then create * : * relationship between Table and Slicer table.

     

     

    Add Slicer_Date column to the slicer on page1, and synchronize slicer to other pages.

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

    Best Regards,
    Winniz

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

v-kkf-msft's avatar
v-kkf-msft
Community Support
5 years ago

Hi lavankumar1989a ,

 

If you want to filter multiple visuals in this way, I think it is more convenient to create a direct correspondence between the date of the slicer and the date to be filtered. Try the following cade in Power Query:

 

let
    Source = Table.FromValue(#"Table"[Date], [DefaultColumnName = "Slicer_Date"]),
    #"Removed Duplicates" = Table.Distinct(Source),
    #"Added Custom" = Table.AddColumn(#"Removed Duplicates", "Table_Date", each List.Dates([Slicer_Date],7,#duration(1,0,0,0))),
    #"Expanded Custom" = Table.ExpandListColumn(#"Added Custom", "Table_Date")
in
    #"Expanded Custom"

 

Then create * : * relationship between Table and Slicer table.

 

 

Add Slicer_Date column to the slicer on page1, and synchronize slicer to other pages.

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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

  • lavankumar1989a's avatar
    lavankumar1989a
    Helper II
    5 years ago

    Thanks much v-kkf-msft, solution which you provided meets my requirement and i need one more help that is,

    if i select a date from slicer table like 06/01/2021, all the remaining visuals has to show data for next 7 days 

    So kindly sugest to achive it. Thanks in advance for your kind support and help.

     

     

    Thanks,

    Lavan

    • v-kkf-msft's avatar
      v-kkf-msft
      Community Support
      5 years ago

      Hi lavankumar1989a ，

       

      You only need to create relationships between Table and other tables.

       

       

      Best Regards,
      Winniz