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

     

     

     

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

       

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

        Hi Anonymous ,

         

        How to get the value of around 40%?Can you upload a pic showing the line in Tableau ? Based on the data you showed in the post,the line should be as below:

         

         
        Best Regards,
        Kelly
        Did I answer your question? Mark my post as a solution!