Combine multiple rows into single one for use of clustered chart

[mshashmi]

Hi everyone

I have a table suppose like this

Table

Column1         Column2

11                     Closed

56                     Open

82                     Resolved

78                     Unresolved

Now I want to make a clustered column chart. It should have two bars, one for both open and unresolved i.e. total 134 and another for closed and resolved i.e. total 93.

How can this be done?

[GilbertQ · Accepted solution]

Hi @mshashmi

I would suggest doing it with the following measure

Total = sum('table1'[Column1])

Open & Unresolved = CALCULATE([Total],'Table1'[Column2] = "Open" && 'Table1'[Column2] ="Unresolved")

Closed & Resolved = CALCULATE([Total],'Table1'[Column2] = "Closed" && 'Table1'[Column2] ="Resolved")

And you can then use those two measures on your clustered column chart.

[GilbertQ · Accepted solution]

Hi @mshashmi

I would suggest doing it with the following measure

Total = sum('table1'[Column1])

Open & Unresolved = CALCULATE([Total],'Table1'[Column2] = "Open" && 'Table1'[Column2] ="Unresolved")

Closed & Resolved = CALCULATE([Total],'Table1'[Column2] = "Closed" && 'Table1'[Column2] ="Resolved")

And you can then use those two measures on your clustered column chart.

[mshashmi]

@GilbertQ Thanks

It worked perfectly

[v-chuncz-msft · Accepted solution]

@mshashmi,

Just to correct it. In this case, we'll use the OR operator (||), not the AND operator (&&).

[mshashmi]

@v-chuncz-msft Thanks

I figured it out though

[GilbertQ]

Glad to help out.