Forum Discussion
How to create two or three Switches
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
Thank you for your time.
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
4 Replies
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:
Regards,
Xiaoxin Sheng
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
Any idea how can we produce the 2nd part of solution ?
Thank you again !!
