Forum Discussion
Get Dynamic Table Based on Slicer Value
Super UserKyle_Willey
While creating a table or calculated column in Power BI, capturing slicer selections in real-time isn't feasible. Power BI constructs tables and columns before making them available on the report canvas. To assist you more effectively, kindly explain your requirements clearly, furnish sample data, and outline the expected outcome. This will enable a tailored solution to meet your specific needs. An approach using Measures should work in your case.
Fowmy, I am not sure how measures would solve my issue. For further explanation, I have several KPIs that I have written measures to handle, each of which switch with the risk analysis model selected by the slicers. However, in addition to the KPIs, I need to have a bar chart with the sum of infCount by month that also switches risk models (each on a different table) with the slicer. I also have a bar chart with the sum of infCount by location with the same requirement.
Each risk model is housed in it's own table. I can write a measure to do a simple sum/count/etc. The trouble is when I am trying to sum by month or by location AND have to specify which table to pull the data from with the slicer.