Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Coming chart issue

Hello experts, i need help in finding solution or workaround for an issue. so I have a cluster column line chart where x axis is text type, left Y axis for column is amount in thpusands ranging fro...
Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    Hi Anonymous ,

     

    maybe this dirty trick will help

    PBIX

     

     

     

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi Anonymous ,

 

maybe this dirty trick will help

PBIX

 

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks a lot for your help. So you converted baseline amount to percentage and then placed it. I do not know the back end calculation in data base for creating baseline .So, converting it to percentage based on whole table might be complex. Will think about it.

thanks again.

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    Excellent solution from mwegener  ,better check it,if there's any question,you can also ask me.I'm also available and willing to solve any problem from you.

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
    • mwegener's avatar
      mwegener
      Most Valuable Professional
      6 years ago

      Thank you v-kelly-msft.
      Do not be shy and give Kudos. 😉

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        I tried it. Yes, the line is coming around 900 in left Y axis. But it came around 60% in Y right axis in PBI. The graph  I have in Tableau for verification shows the same line passes around 40% in Y right axis. Soon probably I am close . But not there yet.

        thanks again