Forum Discussion

kkanda's avatar
kkanda
Icon for Resolver II rankResolver II
3 years ago
Solved

Bar chart with marking for Quarters

I am representing the annual target on a bar chart and comparing with the completion data every month during the year. The monthly data is cumulative - that is April data consists of the sum of four ...
Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi, kkanda 

    Thanks for your quick response！

    Sorry I misunderstood you, from your description you want to divide one of your values into 4 equal parts.

    This is my test data:

    We can create three measures as the constant line.

    Q1 = [Total]/4
    Q2 = [Total]/2
    Q3 = ([Total]/4)*3

    Then we can configure the measure on the "Constant Line":

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

kkanda's avatar
kkanda
Icon for Resolver II rankResolver II
3 years ago

Probably I was not clear what I am looking for. In the attached chart, 1064 is the annual target and 250 is the completed number up to end of April. The X- Axis is a number and there is no Y-Axis. I want the bar representing 1064 to be divided in 4 equal parts marking as "Q1", "Q2", "Q3" and "Q4". 

 

  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi, kkanda 

    Thanks for your quick response！

    Sorry I misunderstood you, from your description you want to divide one of your values into 4 equal parts.

    This is my test data:

    We can create three measures as the constant line.

    Q1 = [Total]/4
    Q2 = [Total]/2
    Q3 = ([Total]/4)*3

    Then we can configure the measure on the "Constant Line":

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly