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

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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ，

     

    I‘ve tried Xviz multiple axes chart,but seems not a good solution for you,see below:

     

    As you said in the last reply,the sample data has only 3 rows from dataset,but there are  thousands of rows actually.So just try the method we suggested,you may get the value you need.

     

     
    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi ,

    I could make the value 42% now. Used same idea but only added some filters instead of All. Thanks for the trick.

    So in card it is showing 42%. But when I am putting in visual as line, it's not coming as a straight line thru the span of months in X Axis. Instead showing a curvy line with numbers ranging from 36 to 89% for different months. 
    how do I get straight line? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Actually I solved my issue, created a column with same Dax and did average, and that worked nicely. Thanks a lot