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. In combo chart, there is nothing in analytics pane.

sample data looks like below:

Date.              Text.               Amt.    %.      Baseline

01012017.   1st of year.       1000.   30.       900

12312016.   End last year.     700.    20.       900

 

X axis text, y left axis for column amount, y right axis %, tooltip date.

howdo I put baseline date as a horizontal line which is amount data?

thanks

 

 

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. 😉