Two line Charts in Power BI

  • Two line Charts in Power BI

    Posted by DSC Communities on April 18, 2020 at 3:56 pm
    • GĆ©rard Ducouret

      Member

      April 18, 2020 at 3:56 PM

      Hi,

      In the attached screenshot I have two Line Charts : A green one : Average Sales over last 30 days and Sales Amount ( Gray)
      Obviously, the gray line covers the green one. I want the contrary :
      Gray line in the background,
      Green line foregroundĀ 
      How can I do that?

      Thanks and regards

      ——————————
      GƩrard Ducouret
      ——————————

    • Vincent Lacomme

      Member

      April 19, 2020 at 4:33 AM

      Hi GƩrard,

      You have to sort the columns in descending order in the “value” field of the line chart.

      Example :
      Column 1
      Column 2
      Column 3

      This will result in Column 3 being the first visible line, then column 2 will be shown and column 1 will be in the background.

      After reordering, open any other page of your PBIX then come back to the page to have the changes applied.

      ——————————
      Vincent L.
      Chartered accountant – Expert-comptable
      ——————————
      ——————————————-

    • GĆ©rard Ducouret

      Member

      April 19, 2020 at 12:41 PM

      Hi Vincent
      Great! That works!
      The trick I missed was : “After reordering, open any other page of your PBIX then come back to the page to have the changes applied.”
      Thanks a lot !!!

      ——————————
      GƩrard Ducouret
      ——————————
      ——————————————-

    DSC Communities replied 5 years, 11 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Two line Charts in Power BI’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for peopleĀ  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!