Forum Discussion
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 - Cummulative in Line axis and Mesh Roof is Column
Please suggest
Then prefer using measure to calculate sum of value and cumilative value separatly using measure
this will solve your problem
6 Replies
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 columnWith the measures you provided , its giving me the result below
Provided you the sample file
https://github.com/suvechha/samplepbi/blob/main/p6.pbixThen prefer using measure to calculate sum of value and cumilative value separatly using measure
this will solve your problem
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
