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!

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft 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