Forum Discussion
Helper IVArea chart - include daily changes in Year -view
I have a report showing accumulated stock amounts from beginning of times and in the chart below I can see yearly changes. However this vies doesn't include monthly /daily changes in stock. Is it possible to include them in the same view?
At the moment I can drill down for sure but this view isn't realistic as there can be big stock movements just before year end and thus the yearly figure can be biased.
Thanks in advance!
Jenny
HI dhannaa,
>>Is it possible to include them in the same view?
I think it is impossible to show the daily change if you remove all of other hierarchy level.
In addition, if you want to write a measure who dynamic changed based on drill down level, you can refer to below link:
Get drill down hierarchy level from Axis on column chart with DAX?Regards,
Xiaoxin Sheng
5 Replies
HI dhannaa,
>>Is it possible to include them in the same view?
I think it is impossible to show the daily change if you remove all of other hierarchy level.
In addition, if you want to write a measure who dynamic changed based on drill down level, you can refer to below link:
Get drill down hierarchy level from Axis on column chart with DAX?Regards,
Xiaoxin Sheng
dhannaaThanks!
Finally got the view work as I wanted it to. Is this icon the smartest way to show all levels at once or is there some better way?
.
Jenny
HI dhannaa,
If you want to show them at once, it seems the better way.If you want to drill down specific label, you can try to turn on the drill down feature then click on which one you want to drill down.
Regards,
Xiaoxin sheng