Forum Discussion

dhannaa's avatar
dhannaa
Icon for Helper IV rankHelper IV
9 years ago
Solved

Area 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 pos...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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

  • dhannaa's avatar
    dhannaa
    Icon for Helper IV rankHelper IV
    9 years ago

    Thanks!

     

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      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

      • dhannaa's avatar
        dhannaa
        Icon for Helper IV rankHelper IV
        8 years ago

        I've got one more issue with this. So I am trying to get stock changes for different years to be compared  with each other. Below an example.

         

         

        Everything works fine but as I want graphs to draw daily data, the chart becomes superwide horizontally. I thought this was an easy fix,  but not so easy after all - is there some fix I dont realize?

         

        Data drawn should be at daily level but there is no need for every single date on the axis. :)

         

        Jenny