Forum Discussion
achicoria
8 years agoRegular Visitor
Clustered Column Chart - Grouping Doubt
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?
- Anonymous8 years ago
achicoria,
Please check the chart in PBIX file below.
https://1drv.ms/u/s!AhsotbnGu1Nok3Qr6WB2GQVN9rfm
Regards,
Lydia
2 Replies
- AnonymousNot applicable
achicoria,
Please check the chart in PBIX file below.
https://1drv.ms/u/s!AhsotbnGu1Nok3Qr6WB2GQVN9rfm
Regards,
Lydia - StachuCommunity Champion
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#M199357works for you