Forum Discussion
Solved
Need help in Combo Chart - Visual
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...
Then prefer using measure to calculate sum of value and cumilative value separatly using measure
this will solve your problem
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
)