Line Graph to start with zero at the beginning

[Anonymous]

Hello All,

I need some help on this. I have a treemap that displays all the system in my organization with their yearly score. Then i have a corresponding line graph that displays the monthly broken down score when a system is selected in the treemap. What is currently happening is when the report is open , the treemap shows everything (which is what i want) but the line graph shows SUM of all the scores for all the system totaled up. I dont want that. T just want it to show 0 for all the months (when nothing is selected) and then when a system is selected in the treemap, display its corresponding monthly value in the line graph. How do i do so?

I dont have a URL where i can post the screen shots , sorry.

Thank you!

[mwegener · Accepted solution]

Hi @Anonymous ,

create a measure and check if system has only one value.

https://docs.microsoft.com/en-us/dax/hasonevalue-function-dax

Measure =IF(HASONEVALUE(Table[system]),
		SUM(Table[value]),
		BLANK())

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[Anonymous]

Thank you so much sir, you solved my biggest issue. Awedome job