Forum Discussion

MP_123's avatar
MP_123
Icon for Microsoft Employee rankMicrosoft 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
MP_123's avatar
MP_123
Icon for Microsoft Employee rankMicrosoft 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
Icon for Memorable Member rankMemorable 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.