Forum Discussion
Create a Slicer to toggle between millions and thousands
Hello Community, I have a matrix table displaying values for accounts. All the columns are calculated measure. I want to add a slicer for this report so that user can ...
Anonymous see attached, I just created a selection table for slicer and also added a column for Denominator
Just for example, in Plan measure, I used Denominator based on the slicer selection and default is kept to 1000. You can apply the same technique to other measures
parry2k
Super User
Super UserAnonymous see attached, I just created a selection table for slicer and also added a column for Denominator
Just for example, in Plan measure, I used Denominator based on the slicer selection and default is kept to 1000. You can apply the same technique to other measures
parry2k Thank You, Your solution works perfect.