Forum Discussion

Kelsey024's avatar
Kelsey024
Frequent Visitor
8 years ago

Dynamic reference line for stacked bar chart

Is there a way to create a dynamic reference line to a stacked bar chart that has the line change depending on the month filtered? For a stacked bar chart, the only input constant is available. I would like this line to change depending on the month filtered. 

 

Thanks,

Kelsey 

Need Help

1 Reply

  • MFelix's avatar
    MFelix
    Super User
    8 years ago

    Hi Kelsey024,

     

    This line as you said is a constant so it's not related with the data so you cannot make it variable you can use a Line and stacked bar make a calculated measure for the line part, or a "dirty" way of doing this would be to create one chart per month and then hiding them and with the book marks present the information for the month you want.

     

    Regards,

    MFelix