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

     

     

     

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!
      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Thanks Kelly,

        the data I post only 3 rows from dataset. I have thousands of rows. And as I mentioned, I do not know the backend calculation for baseline. The average amount for baseline is coming as 900.

        do you thing Xviz multiple axes chart might work here?