Forum Discussion
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 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!
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.
2 Replies
- mwegener
Most Valuable Professional
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.