Separating data

[NithinBN]

Hello,

I have a table like this,

 How to get graph, having JAN and FEB on X-axis, with sum of A JAN and T JAN for JAN and sum of A FEB and T FEB for FEB.

Thanks!

[PhilipTreacy · Accepted solution]

Hi @NithinBN 

Wasn't sure exactly what you wanted but this PBIX file contains both of these charts

Regards

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[BI_Jo]

Hi,

Is this the result you're looking for?

To get this I transformed the table in Power Query Editor with these steps:

1. Created a new 'JAN' column that summed the values from columns 'A JAN' and 'T JAN'

2. Created a new 'FEB' column that summed the values from columns 'A FEB' and 'T FEB'

3. Removed all columns other than 'JAN' and 'FEB'

4. Then highlighted the 'JAN' and 'FEB columns and unpivoted the table.

You can then create the above graph.  Hope that was the type of solution you were looking for!

Jo