CODEWITHSUNDEEP
powerbi
Ivan Nel
Ivan Nel

Reputation: 325

PowerBI Slicer Group

UPDATED. I want to create a Slicer Group with options (MTD,YTD) to display only rows relevant to that selection,

enter image description here

From the Table above, Group MTD must display columns A,B,C,D below, and Group YTD must show columns A,E,F,G.

I would appreciate any help in this regard

Upvotes: 0

Views: 32

Answers (1)

Ryan
Ryan

Reputation: 2412

here is a workaround for you.

  1. create two pages. One is MTD. The other is YTD.

create two boxes for measure selection.

Display MTD related measures in the MTD page and display YTD related measures in YTD page.

enter image description here

  1. in the MTD page, set the YTD box to page navigation and the destination is YTD page.

enter image description here

in the YTD page, set the MTD box to page navigation and the destination is MTD page. enter image description here

then you can press Ctrl and click the box to jump between these two pages.

Upvotes: 0

Related Questions