Need help in Combo Chart - Visual

[ashmitp869]

Hi ,

Help me with the Combo Chart.
I have a sample chart requirement .

I have data set like

I have used Line and Stacked Column Chart. But how can I show the Mesh Roof - Cummulative in Line axis and Mesh Roof is Column

Please suggest

[Vijay_Chethan]

You can use measures to calculate sum of value for two mesh categories
add sum of value in column field and measure to calculate cumilative(if u dont already have a column for it), and add it in line axis, this will give you the desired combo chart, if you are worried about legend, you will get legend considering column field and line field, just name them in visual accordingly

please mark this as solution if it helps

[govind_021]

Hi @ashmitp869 
you need to create a Mesh Roof - Cummulative dax measure using DAX 
here is the sample formula
Cumulative Total =
VAR SelectedDate = MAX('Date'[Date])
RETURN
CALCULATE(
SUM('Sales'[Amount]),
FILTER(
ALL('Date'),
'Date'[Date] <= SelectedDate
)

and use this measure in Line y axis section of the visual.


Best Regards
Govind Sapkade ( Microsoft Certified Data Analyst , PL 300 Certified , MS Fabric Enthusiast)
Let's Connect
Linkdin - www.linkedin.com/in/govind-sapkade-845104225
Youtube - http://www.youtube.com/@govind_dataanalyst
)

[ashmitp869]

Hi @govind_021 
But I already have the cummlative value in the Value column

With the measures you provided , its giving me the result below

Provided you the sample file
https://github.com/suvechha/samplepbi/blob/main/p6.pbix

[govind_021]

Hi @ashmitp869 
attached the pbix file with solution , please have a look
https://drive.google.com/file/d/1pOb8XT5WWD6nmO8irls0dVR7a5BEc6BY/view?usp=drive_link

Best Regards
Govind Sapkade ( Microsoft Certified Data Analyst , PL 300 Certified , MS Fabric Enthusiast)
Let's Connect
Linkdin - www.linkedin.com/in/govind-sapkade-845104225
Youtube - http://www.youtube.com/@govind_dataanalyst

[ashmitp869]

Unable to get the pbix file. Access denied

[Vijay_Chethan · Accepted solution]

Then prefer using measure to calculate sum of value and cumilative value separatly using measure
this will solve your problem