Forum Discussion
Clustered Bar Chart - How to visualize both static data and calculated data together?
Replace your calculated/static table with a pure disconnected “axis”/“selection” table containing only Metric and Year (NO data values).
Calculated table will not act dynamic so you will only need to have a helper table with the combination of metric and year and not the actual values of 2025. In the suggestion above, I request using the measure defined and calculating 2025 data in real time which will make it dynamic and get reflected changing based on the slicer selection. Make sure to not include the data into the calculated table. Let me know if you need further clarification or provide sample data for further analysis.
Super User"any filters/slicers that I try to use on the report do not affect"..
If you want the last years data to be sliced-able, you must have the data in the same granularity as this years data, data. And the dimensions that you use to filter and slice must have relationships to the previous years data table.
I do know that slicers will not affect the last year's data since it is static, but more precisely, I need to be able to filter the current year data for the visual, and my method of putting the static and calculated data together in one table results in data that is not filterable in report view.