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.
Thank you for your reply. I think that's pretty similar to what I did. My code was:
Super UserReplace 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.
Thank you, MohamedFowzan1 . I will try that solution and try to check back in if it works.