Need this report with double switches button

[SpiroswayGR]

Hello everyone,

I would to explain a common problem that i have when i need to create switch slicers.

Our PBI report should be like this https://prnt.sc/ql5uio .

Our expectation is to create the same report but we have to select ( or see ) our metric (Revenue , sold rooms , Pax etc) and 2nd selection slicer (Net , Gross)(different column) and 3rd selection date slicer (you should create that from operational date that we have it) as a button (YTD , future dates (today until end of the year) , all season).Most important slicers are 2nd and 3rd one.

On each row of data i have one value that is net amount and on the same row i have the gross amount.

Any idea ?

[SpiroswayGR · Accepted solution]

Attached file with expected results

https://we.tl/t-QSW64EanZm

Thank you for your time.

[SpiroswayGR · Accepted solution]

Attached file with expected results

https://we.tl/t-QSW64EanZm

Thank you for your time.

[SpiroswayGR · Accepted solution]

Any suggestion on this problem ? !!💡