one value and Others on visuals

[MP_123]

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!

[tringuyenminh92]

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]

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]

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

[Baskar]

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. 

[tringuyenminh92]

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.