The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hey Guy,
I am new to Power Bi and I am having a hard time doing something that may be for you is a piece of cake.
I have a bar chart where the column value calculates monthly sales and a line value that calculate the average sales for the past 6 months, now when I exclude a bar from the chart by clicking on exclude, the average should dynamically exclude the excluded month and recalculate the average for the past 5 months instead of 6, it this possible?
Here is my calculate
Hi, @v-easonf-msft ,
There is no problem with the formula, I need to make the -6 in my formula dynamic, so when they click on a specific bar on the bar chart and hit exclud, whatever they exclude, should be reflected in the formula.
I Belive it is not possible to reference a filter in a formula.
Let me know if I explained this properly.
Thank you very much.
Zied
Hi, @zrouatbi
I don't see any problem with the formula you provided.
Please share a sample file to further illustrate your needs.
Best Regards,
Community Support Team _ Eason
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
81 | |
63 | |
56 |
User | Count |
---|---|
247 | |
122 | |
110 | |
77 | |
72 |