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.
I have a line chart in Power BI that has the X by Fiscal Year. I also have a filter on the chart limiting the range of the fiscal years (I have more years than needed for the chart). On the same page is a slicer that shows Country (related table). There are countries listed in the slicer that are not in the table range. I tried using the examples of using DAX to hide slicer data that does not have a value and it hid a few things. However some of the Countries have data listed outside the date range in the line chart. So the slicer still shows them. This is making the country list slicer much larger than it should be.
Is there a way to filter the slicer based on the filters set in another visual?
I also tried setting the fiscal year limits in the DAX slicer code, however the code for that did not seem to work (other tables for fiscal year etc…) In some ways this seemed like the best idea. If I worked right I could apply the DAX Slicer filter to both the Slicer and the line chart (maybe??)
Thoughts and ideas?
Thanks
Alan
I had started with examples from here
Hi @asjones .
Wihtou any data is difficult to give the exact answer but in this case you need to use a crossfilter function to get a measure that filters out the values you don't need, of course this depends on the data model you have.
Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |