Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Create a functionality to change table date levels (i.e.Months, Quarters, Years)

Hello,

 

I have some dashboard users who use dashboards via mobile phone.

In mobile phones there is no functionality to drill up and down table levels. Therefore, I need to create a function that enables dashboard users to change Table date level (i.e. Month to Quarter and Quarter to Year and back). 

Can you please share with me some ideas on how to do this?

 

Many thanks!

Need Help
Tips and Tricks

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Anonymous，

    Please take a look at the following blog, you can make a slicer with options of Year, Quarter and Month for end users. When users select one of the options, visuals will display related aggregated values.

    http://radacad.com/dynamic-x-axis-on-charts-power-bi

    Regards，
    Lydia

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago
      Hello Lydia,

      Many thanks for your answer. This idea is useful, however it does not solve my problem. My client wants when he chooses to see Quarters, to have aggregated data (i.e. for quarter1 to see the sum of quarter 1 and not the sums of January February and March).

      I hope this is clear.