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!