Total Bar in Hierarchical Bat Chart

[Chirag_4370]

I'm trying to get display Sub total and Grend Total on bar chart.

[Anonymous]

Hi @Chirag_4370 ,

In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Chirag_4370]

@Anonymous Thank You fow show interest. 

Values for "Total" derived by DAX: 

Val+Total = 
VAR total = CALCULATE(SUM(Data[Val]), ALLSELECTED('Data'))

RETURN
IF(
    SELECTEDVALUE('Date'[DateText]) = "Total" || SELECTEDVALUE(Cat[Cat]) = "Total",
    total,
    SUM(Data[Val])
)