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.
My DAX formula to create the table is:
In the page report, I also have a slicer that shows all the values of another column of the factDonorReport. Whenever I try to modify the filter context by selecting one or more values of the slicer, the graph doesn't update.
I was hoping that the filter context set with the slicer on the factDonorReport would propagate to the values in the new table but it doesn't. Does anyone have any idea how this might work?
Thank you and regards,
lorenzocc
Solved! Go to Solution.
@lorenzocc , Calculated table can not take slicer filter.
Only tables created as var in Measure can take filter/slicer Value
Thank you for the response. Although what you are saying is not entirely clear, it is also true and was helpful in solving it.
What I did was to create a single measure that calculated the ratio between the sum(factDonorReport[percExpenditure]) and sum(factDonorReport[percBudget]) in a CALCULATE formula that reset all filters except for those accessible through the slicer(s) with an ALLEXCEPT statement.
After which, I did not create a new table based on this calculated measure but instead worked directly on the visualization. I placed factDonorTable[fiscal_year] in the x_axis field and the new measure on the Values field. This seemed to work fine since a filter context (transitioned from a row context) was created by the x_axis and was intersected with the current filter context created by the slicers.
@lorenzocc , Calculated table can not take slicer filter.
Only tables created as var in Measure can take filter/slicer Value
Thank you for the response. Although what you are saying is not entirely clear, it is also true and was helpful in solving it.
What I did was to create a single measure that calculated the ratio between the sum(factDonorReport[percExpenditure]) and sum(factDonorReport[percBudget]) in a CALCULATE formula that reset all filters except for those accessible through the slicer(s) with an ALLEXCEPT statement.
After which, I did not create a new table based on this calculated measure but instead worked directly on the visualization. I placed factDonorTable[fiscal_year] in the x_axis field and the new measure on the Values field. This seemed to work fine since a filter context (transitioned from a row context) was created by the x_axis and was intersected with the current filter context created by the slicers.
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 |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |