Cholumn chart - one chart data from two different periods and spited by measures result

[ewakol]

Hello,

i feel that my head want to explode, will be very appreciate for help.

I have data for 21 warehouses, for each WH i calculated KPI1 and KPI2 as a meassure. Result could be in target, close to target, or out of target. Now i show data for 12 and 3 months in table with colours (time period is set by slicer). My boss asked, can we also show it on chart. So i need to compare on one chart data from two different periods and splited by 3 mentioned target type, dependent on rule between KPI1 and KP2:
GREEN = green + green
ORANGE = green + orange or orange + orange
RED = all the rest

Chart should look as on the right.

Any idea how can i do that?

[elitesmitpatel]

Share a dummy pbix file.

[Selva-Salimi · Accepted solution]

Hi @ewakol 

first of all you should create a table (target_types) which has one column of target type and insert "in target, close to target, , out of target" in the rows and also you can have a column target_id from 1 to 3 to simply manage. then use target type in the X-axis.

then you can relate this table to the column that you use in your legend of the visual. and write a measue kpi1+kpi2 and show that on the visual.

If this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.