Forum Discussion
Populate table and graph depending custom filters
Hello, I am facing an issue here. I want to create a custom slicer to allow my end user to choose between different income levels. My income is based on a measure. I created a custom filter wit...
Have you tried creating an extra column in your Customer table to Categorise each customer into one of these groups? e.g. '<50k'.
Then you can just join your Slicer table to your Customer table using the matching field.
My problem here is that my ARR is calculated on the whole column and when I use it I add a filter on the dashboard to get the last calendar month. So based on your solution, I should create a columns and calculate my ARR for each month value I have for each client?
If it's only the last month you need for this data then you could create a summarised table by Customer, Last Month ARR, and Category