Forum Discussion

Boudewijn's avatar
Boudewijn
Frequent Visitor
7 years ago
Solved

Slicer filter another slicer

Power BI Set up; - 1 Table - Slicer 1 (Between) for column A (Values) - Slicer 2 (Between) for column B (Date)   Goal: [Count values filtered by slicer 1 and slicer 2] divided by [Count Values ...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Boudewijn

    in my test, 

    [Count values filtered by slicer 1 and slicer 2] ---Measure

    divided by

    [Count Values filtered only by slicer 2]    ---------Measure 2

     

    Best Regards

    Maggie

     

Boudewijn's avatar
Boudewijn
Frequent Visitor
7 years ago

I found the problem;

 

If the slicer 2 (between) for column B (date) is formatted as date (1-1-2018  / 31-12-2018), it will not work.

 

If the slicer 2 (between) for column B (date) is formatted as decimal (2018 / 2018), it work's.

 

What to do if I want to filter on date format???