How to create two or three Switches

[SpiroswayGR]

Greetings everyone!! It's urgent problem!!

I would to explain mine urgent 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.

Attached file with expected results

https://we.tl/t-QSW64EanZm

Thank you for your time.

[Anonymous]

HI @SpiroswayGR,

I'd like to suggest you unpivoted these columns to attribute and value, then you can simply write measure formula to switch between different fields:

Unpivot columns (Power Query) 

Regards,

Xiaoxin Sheng

[SpiroswayGR]

Thank you @Anonymous .

With your suggestion i manage to solve the 1st part of problem.(About Net / Gross values).

What about "Slicer" dates button? I have the "Date" column.

So the suggestion is to create Past - Future - All season .

Past = 01/01 until yesterday 

Future = Today until end of the year 31/12

All Season = 01/01 to 31/12

In that i want to click on these specific slicer button and i want to see the different "Revenue values etc".

Thank you in advance for your time.

[Anonymous · Accepted solution]

HI @SpiroswayGR,

You can try to use the bookmark feature to save a specific filter range as a bookmark and use button 'action' option to binding to click button event to a specific bookmark.

Create bookmarks in Power BI Desktop to share insights and build stories 

Regards,

Xiaoxin Sheng

[SpiroswayGR]

@Anonymous 

Any idea how can we produce the 2nd part of solution ? 

Thank you again !!