Forum Discussion
Need help in Combo Chart - Visual
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
)
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
Then prefer using measure to calculate sum of value and cumilative value separatly using measure
this will solve your problemHi 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_dataanalystUnable to get the pbix file. Access denied