Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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 @v-shex-msft .
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
98 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |