cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## clustered column chart include and exclude

hi dears

i want to create clustered column chart

i have the below data

i need to insert two columns chart to compare between car type (

in the first column i need to insert all cars and exclude Nissan

in the second column i need to insert Nissan and exclude the rest of the cars

how do i do that?   ( i dont want to insert filter )

1 ACCEPTED SOLUTION
Community Support

Hi @anglefbi11

You'll need to create two DAX measures to calculate the values for each of your columns. The first measure will sum up the values for all cars except Nissan, and the second measure will sum up the values for Nissan only.

``All Cars Except Nissan = CALCULATE(SUM('Table'[value]), 'Table'[Cars] <> "nissan")``
``Nissan only = CALCULATE(SUM('Table'[value]), 'Table'[Cars] = "nissan")``

Result:

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 REPLIES 4
Community Support

Hi @anglefbi11

You'll need to create two DAX measures to calculate the values for each of your columns. The first measure will sum up the values for all cars except Nissan, and the second measure will sum up the values for Nissan only.

``All Cars Except Nissan = CALCULATE(SUM('Table'[value]), 'Table'[Cars] <> "nissan")``
``Nissan only = CALCULATE(SUM('Table'[value]), 'Table'[Cars] = "nissan")``

Result:

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helper I

godbless you brother . it work 100 % thank you very much

Super User

each visual on a page can have its own filter. See in the Filter pane to Filter on Visual

Helper I

it wont work

because if you could see i have only one column for data.

i need to inseret two clustered column column in the same visual

so when i use the visual filter it will not work as i expect