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.
Hi,
I have a table which has data for both Actuals and Budgets, the Budgets are split into 'versions', the actuals aren't. The data in the report needs to change based on a date selection to show actuals to a certain date, with budgets from that date, I have this part working.
I want to be able to filter the budget by the version, enforcing a selection if possible. So the user chooses a date, and can toggle the available budget versions, but I can't find a way to do this and apply it only to the budget and not the actuals.
This is the current measure:
Hi @simonb,
Since I'm not so clear for your table structure, can you please share some dummy data and expected results with a similar data structure to help us clarify your scenario and test to coding formula?
Regards,
Xiaoxin Sheng
So, you should be able to do that via ALL, ALLEXCEPT, KEEPFILTERS, REMOVEFILTERS, etc. Tough to be specific. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |