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.
The problem:
I have this visual chart showing YTD sessions. The rest of the page is controlled by a Slicer to choose a FY_week_number, but this sessions visual should show all sessions from start of Year, LESS than chosen FY_week_number
Because I have the interaction between the FY_week_number and this visualisation to be DISABLED, I am wondering how I can control the Sessions YTD figure to be LESS THAN the selected FY_week_number from the slicer?
Hmmm?
Hi @Anonymous,
Could you please mark the proper answers as solutions?
Best Regards,
Dale
@v-jiascu-msft - If there was a proper solution, I would mark it as such. I do not feel that the question is answered at this time.
Hi @Anonymous,
Since you have disabled the interaction, the filed of the x-axis can't be from the same table with the slicer filed. So there could be two solutions.
1. If there are two tables without any relationships, it could be easy.
2. If there are two date tables with relationships, you can create a measure. Can you share a dummy sample? Then you can have a precise solution.
Best Regards,
Dale
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 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |