Forum Discussion

madhav2020's avatar
madhav2020
Frequent Visitor
5 years ago

Reference line on X-axis based on slicer selection

Hello Folks,

 

Am looking to achieve such a visual on line and clustered column chart.

 

As when i select option in slicer, reference lines should appear on chart. Any leads will be of great help.

 

Meanwhile i have refered this video (https://www.youtube.com/watch?v=XKmTknbusnY&t=263s) to find a relevent solution.

But was not possible and reason being time in slicer doesnt match with that on x-axis. 

 

Thanks for you effort in advance. Please reach me out if you have any clairfication on problem statement. 

 

 

General Comment
Need Help
Tips and Tricks

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    5 years ago

    madhav2020 No standard visual that I know of will do a vertical line in a column chart. Would have to look at custom visuals in the App store, R or Python visuals.

    • madhav2020's avatar
      madhav2020
      Frequent Visitor
      5 years ago

      @

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi, madhav2020 

    What format is the original data of the fields on the x-axis,？

    Can you provide a demo pbix  for testing?

    Best Regards,
    Community Support Team _ Eason
    .

    • madhav2020's avatar
      madhav2020
      Frequent Visitor
      5 years ago

      Hi Team _ Eason,

       

      Original data is in time format. 

       

      Wish i could, but data/pbix  is in client server which i doubt could be reterved !

       

      Regards,

      Sumanth