Forum Discussion

MP_123's avatar
MP_123
Microsoft Employee
9 years ago

one value and Others on visuals

hi, i have column with three different values with name 'columnX':

let's say its values are a,b and c

i have also count measures name Y.

i have slicer with columnX values.

i want to have stacked column chart with columnX to behave like:

when selecting a on the slicer, the column chart will contain a and others

if selecting b , so b and others.

 

is it possible?

thanks!

 

5 Replies

  • Hi MP_123,

     

    Your description is not clearly, could you please show your sample data? so i could understand what we are having.

    • MP_123's avatar
      MP_123
      Microsoft Employee

      hi tringuyenminh92,

      i have column name 'EngagementCohrt'

      its distinct Values:

      -CortanaHeavy

      -CortanaMedium

      -CortanaLight

       

      this column is also slicer.

      i want to add this visual

      but, i want that when CortanaMedium is selected, to get two columns: 'CortanaMedium', 'Others'(sum of light and heavy)

      and if CortanaLight is selected, 'others' will be medium and heavy

       

      thanks!

      • tringuyenminh92's avatar
        tringuyenminh92
        Memorable Member

        Hi MP_123,

         

        I got your point now. Could i have small sample data to try analysis? it's will be help me quickly figure out the solution.