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.
Hey,
I didn't find an iteration of this that had been answered before. I'm trying to find a way to create a dynamic slicer which determines what options to present the user based on other selections the user makes. I can determine what month counts to show the user via measures, however I cannot put measures into a slicer. Similarly I don't think I can use a custom column because I need the slicer logic to determine what dates to show the user based on filtering selections the user makes after the model is loaded in and complete.
Is there a way to dynamically change a slicer based on logical if-then statements?
For Ex:
Available Months at Start: All months 2017-2018
User Inputs Filter, Available Months Now: May (first half), June, July, August (last half)
Logic: For each month that has all data, show that month as an option in the slicer
Slicer: June, July
Thanks!
Solved! Go to Solution.
Thanks for your help Felix!
I couldn't get that solution to work however it helped me think of another solution. I created a table with the options available to the user. The table had 2 columns, one column for the title I wanted the user to see as they selected an option, the second column for the variable I wanted to pass into my equations. Then I went to my equation and referenced the value column of the aforementioned table and said to add that value to my equation.
Thanks again!
Hi @Anonymous,
As you say you cannot create a slicer with a measure, however you can use a measure to filter out a report a page or a visual, in this case I believe that you can use one of two options:
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThank you Felix!
I'll actually need the dynamic slicer to inform a measure that reflects across different tables and graphs so a visual filter won't work in this case. I'll keep that solution in mind for the future though!
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThanks for your help Felix!
I couldn't get that solution to work however it helped me think of another solution. I created a table with the options available to the user. The table had 2 columns, one column for the title I wanted the user to see as they selected an option, the second column for the variable I wanted to pass into my equations. Then I went to my equation and referenced the value column of the aforementioned table and said to add that value to my equation.
Thanks again!
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |