Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Chart - Clustered Column and line

I have this clustered column & line chart.     The issue with it is clearer, even to me, when I show it as a table.     This is how it looks as a table:     What I think ...
Need Help
  • jsaunders_zero9's avatar
    jsaunders_zero9
    4 years ago

    Anonymous 

    Is this what you are trying to acheive?

    Couple of things, Is there any reason that you can't append the you two tables together, they look identical.

    Here is a link to a file that I put together to show you what I mean - mohassan99_sample.pbix.

    I would also suggest you looking into some basic data modelling concepts in Power BI, I re read your first question about your data model and three relationships - relationships don't work how you think they do.

    Thank you

  • Anonymous's avatar
    Anonymous
    4 years ago

    I think I may have to append the tables in a query. Apparently a data relationship is not a join so, yeah, I wasn't sure what they were. 

     

    Thank you,

    Mo

jsaunders_zero9's avatar
jsaunders_zero9
Icon for Responsive Resident rankResponsive Resident
4 years ago

Hi Anonymous 

I would suggest introducing a calendar table and then summing your measures as totals, can you provide some dummy data and I can m show you how.
Thank you

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago
     
     

    Do you mean a date table? PowerBI says:

    A date table is a table that meets the following requirements:

    • It must have a column of data type date (or date/time)—known as the date column.
    • The date column must contain unique values. (Not the case.)
    • The date column must not contain BLANKs.
    • The date column must not have any missing dates.
    • The date column must span full years. A year isn't necessarily a calendar year (January-December).
    • The date table must be marked as a date table.

    The data looks like:

    Query/Data Source 1

    YearProviderValue1

    2020

    		110
    2020110
    2020220
    2020220

     

    Query/Data Source 1

    YearProviderValue1
    2021130
    2021130
    2021240
    2021240
     
     
    • jsaunders_zero9's avatar
      jsaunders_zero9
      Icon for Responsive Resident rankResponsive Resident
      4 years ago

      Anonymous 

      Is this what you are trying to acheive?

      Couple of things, Is there any reason that you can't append the you two tables together, they look identical.

      Here is a link to a file that I put together to show you what I mean - mohassan99_sample.pbix.

      I would also suggest you looking into some basic data modelling concepts in Power BI, I re read your first question about your data model and three relationships - relationships don't work how you think they do.

      Thank you

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        I think I may have to append the tables in a query. Apparently a data relationship is not a join so, yeah, I wasn't sure what they were. 

         

        Thank you,

        Mo