Column with actual target category date

[Archie-gh]

Hi all, 

I need your help, i have those tabel as below and I want to show them in one stacked column visual which included monthly view of Target and actual ( in two seperate column next eachother in each month) and with category ( as legend for both). 

Can anyone hele me?

[amitchandak]

@Archie-gh , two way.

1. Unpivot Actual and Target, which will bring them in rows and you can have desired visual

2. Create a Sum measure on both. And create a calculation group. calculation group will convert the measure to dimension again you can use it visually on the axis

Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

[Archie-gh]

Hi Amit, 

1. Unpivot doesn't make what I need, becasue it add one more category which is ( actual adn Target). I need to show them in one visual with one category, actual and atarget must be shown in columns. the second solution, was showoing the tabel presentation only, and also it needs one Add in which I don't have it