Forum Discussion
Creating a Slicer to select data from different calculated columns
Hi, I've created a table with four calculated columns. These are based on inflation rates and have taken data from different years to factor up to 2020. I am now looking to create a slicer based on ...
Miguel,
Thank you for your response, I'm not sure if I've set up my tables incorrectly, but this doesn't seem to be working for me. I've created the measure, but I'm not sure what I should use for the Reference. I need to think about the layout before trying this out.
Many thanks
David
MFelix
Super User
Super UserHi Anonymous
The reference is just a table that you can call whatever you want and place the name of the column you need to calculate and change, then if you select that table and make the calculations according to the measure your charts should change.
Check PBIX file attach with a small example: