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 ...
Need Help
tringuyenminh92's avatar
tringuyenminh92
Memorable Member
9 years ago

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
    9 years ago

    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
      9 years ago

      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.

    • Baskar's avatar
      Baskar
      Resident Rockstar
      9 years ago

      Sorry , we can't change the dimesion on slicer selection point.

       

      The reason behind this is we can't create dimesion or change dimesion on Run Time .

       

      only measure will change at run time ?

       

      so u can't do like this at run time.

       

      Sorry Again. 

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      9 years ago

      Hi MP_123,

      We are not able to acheive what you want in Power BI desktop. The slicer is used to filter the rows, it only return  'CortanaMedium' when we select the CortanaMedium in slicer. You can post the request on this link.

      Best Regards,
      Angelia