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 ,

 

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

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