Skip to main content
cancel
Showing results for 
Search instead 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

Reply
anglefbi11
Helper I
Helper I

clustered column chart include and exclude

hi dears

 

i want to create clustered column chart 

 

i have the below data

 

anglefbi11_0-1718625578632.png

 

 

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
v-jialongy-msft
Community Support
Community Support

Thank you for your prompt reply! @3CloudThomas 

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:

vjialongymsft_0-1718689475366.png

 

 

 

 

 

 

Best Regards,

Jayleny

 

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

 

 

View solution in original post

4 REPLIES 4
v-jialongy-msft
Community Support
Community Support

Thank you for your prompt reply! @3CloudThomas 

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:

vjialongymsft_0-1718689475366.png

 

 

 

 

 

 

Best Regards,

Jayleny

 

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

 

 

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

3CloudThomas
Super User
Super User

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

3CloudThomas_0-1718627322750.png

 

hi thank you for your reply

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.