Forum Discussion

BTI_Afuentes's avatar
BTI_Afuentes
Helper I
6 years ago

All axis data in line chart

Hi everyone,

 

I need your help please.

I'm trying to display a credit score in a line chart. I have data of the score in one table and in another table the data for the X and Y axis.

At the end, the chart has to be something like this:

Credit scores are related to projects, so, when i select a project, the curve on the chart disappears and only displays the score.

 

This is Before selecting project:

Before selecting project

After selecting project:

After selecting project

 

Another issue would be, how can I ensure that x axis will be always displaying the max number on the list? On the given example, the maximum number is 100 and when I select project changed the scale.

Here is an example with the PBX data:

PBX Example 

 

 

Thank you very much for your help.

 

4 Replies

  • BTI_Afuentes on format pane under chart x-axis, change the type to continuous instead of categorical.

     

    I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

    • BTI_Afuentes's avatar
      BTI_Afuentes
      Helper I

      Hi,

      Thank you for your answer.

      It's already in continuous...

      line chart example_after selecting project_continous.png

      Angel

      • parry2k's avatar
        parry2k
        Super User

        BTI_Afuentes try other option I always end up mixing these options.

         

        sorry about that.

         

        I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

        Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.