Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Line Graph to start with zero at the beginning

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 bro...
Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    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.

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

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