Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to apply different filters for each visual on same report page based on slicer selection date

Hi Guys, I have one quick question on Power BI, basically i have one report which shows client details with consumed products. There are filters on date/month, and client but once i select client , i...
Need Help
V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
6 years ago
Hi Anonymous ,
 
You can create a calendar table and use the date column of the table as a slicer.
You also need to create a measure that displays data for the last six months based on date slicer,
 
Measure =
var slicer_value = SELECTEDVALUE(DimDate[Date])
return IF(MAX(Sales[Date]) <= MAX ( DimDate[Date] )
            && MAX(Sales[Date]) >= EDATE ( MAX(DimDate[Date]), -6 ),1,0)
 
and then apply measure=1 to the visual filter.
You can refer to this pbix.
 
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks Liang. Let me try this out

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Liang,

     

    I tried your solution but it didn't work because in your sample report , you don't join date dimension with sales fact table so it work.


    In my case, I have to join all other event tables with date dimension, and my reporting period slicer come from same date dimension, once i select date from slicer date dimenion table get filter for selected MonthYear so i can't open up last 12 month period to show on visusal.

     

    Please refer sample screenshot of my report, there 3 visuals and highlighted top right visual should display last 12 months, based on selected MonthYear.

     

    For example: User select Date from slicer: 201911, then highloghted visual should display MonthYeat starting from Dec 2018 but once slicer selected 201911 then date dimenion get filtered with 201911 so i can't display 12months on expected visual. Rest visual has to show selected month data.

     

     

     

     

     

     

     

     

     

     

    Thanks,

    Niel

    • V-lianl-msft's avatar
      V-lianl-msft
      Icon for Community Support rankCommunity Support
      6 years ago
      Hi Anonymous ,
       
      Again, you need to create an unrelated calendar table and use this date column as a slicer.
      For detailed steps, please refer to the pbix I provided earlier.
       
      Best Regards,
      Liang
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.