Forum Discussion

NithinBN's avatar
NithinBN
Helper II
5 years ago
Solved

Separating data

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!          
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    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's avatar
BI_Jo
Resolver III
5 years ago

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