Forum Discussion

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 clic...

v-danhe-msft
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
Filter view by day week month.pbix42 KB

Icon for Microsoft Employee rank

Microsoft Employee

7 years ago

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

Filter view by day week month.pbix42 KB

Frequent Visitor

7 years ago

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)