Forum Discussion

rolfstar's avatar
rolfstar
Frequent Visitor
7 years ago
Solved

Filter view by day / week / month

Hello!

I have simple columns

1) Date

 

2) Value

 

I also made a column with weeknumber, so i have 3 different charts.

I need to get 1 chart with filter 'day-week-month' and so when i will click 'day' it will show 1st chart, 'week' second, 'month' - third.

Is it possible?

Need Help

3 Replies

  • v-danhe-msft's avatar
    v-danhe-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi rolfstar,

    You could use the Button and Bookmark function to change different visuals:

    Create three visuals by differnet data and open the Bookmark pane and Selection pane to choose the visual to hide to show with different bookmarks.

    Create three buttons to link the different bookmarks:

    Reference:http://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

     

    You could also download the pbix file to have a view.

     

    Regards,

    Daniel He

    • rolfstar's avatar
      rolfstar
      Frequent Visitor
      7 years ago

      v-danhe-msft

       

      Thank you again for big help!

      I also wanted to ask, 

      I'm trying to get 2 charts on page, so is it possible to click on upper charts buttons and lower chart will not be changed?

      Because when i click "week1" i have weeks on upper and days on lower

      then i click "month2" and i still have weeks on upper and now weeks on lower

      then i finally click "days1" and on upper i have days and on lower i have days (because of bookmark)