Clustered Column Chart - Grouping Doubt

[achicoria]

Helloy Guys.

I facing with a challenge here.

I have a data that is structured in the way bellow:

Name	Product	Non Opt Cost 1 Year	Non Opt Cost 3 Year	Opt Cost 1 Year	Opt Cost 3 Year
Name 1	Product 1	R$3.000,00	R$1.000,00	R$1.000,00	R$500,00
Name 1	Product 2	R$4.000,00	R$2.000,00	R$2.000,00	R$1.000,00
Name 1	Product 3	R$6.000,00	R$3.000,00	R$3.000,00	R$1.500,00

I want to build a clustered column chart that segregate the non opt costs of the opt costs, like the dash below:

Could anyone help me to archieve that goal?

[Anonymous · Accepted solution]

@achicoria,

Please check the chart in PBIX file below.

https://1drv.ms/u/s!AhsotbnGu1Nok3Qr6WB2GQVN9rfm

Regards,
Lydia

[Stachu]

you need to have a separate attribute, that would group optimized/non optimized
please check if the solution from this post:
https://community.powerbi.com/t5/Desktop/Dynamic-Measure-selection-Actual-and-Forecast/m-p/432539#M1...

works for you