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 created a topn single value fiscal year slicer. The goal was to show all fiscal years less then or equal to the number value entered in the slicer. So if 2 was selected it would show 2023 and 2022. I did this by creating a parameter and then creating a calcuation to use as a filter on each of my visuals. It was working perfect for all charts until I tried to apply to a matrix chart. When I add Fiscal year to the columns and add text in the rows it shows for all fiscal years rather then the slicer. It only does this for that one instense and i can't make sense of this. Is there any way to fix this?
https://drive.google.com/file/d/14Nx3AHoOBk_106QN8zCgQAStfZzarghd/view?usp=sharing
Solved! Go to Solution.
Hi @ROCKYDO12 ,
Change the relationship to "Both" and the problem will be solved.
Best Regards,
Jay
Hi @ROCKYDO12 ,
Change the relationship to "Both" and the problem will be solved.
Best Regards,
Jay
I don't have a relationship set up but as soon as I set it up with calendar between fy rank it only closers for single year
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 |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |