Forum Discussion

janinedev's avatar
janinedev
Frequent Visitor
2 years ago
Solved

Visual not showing based on Date Table

Hi there! I'm running into a snag with the date table I connected to my main table. I'm aiming to display all the records and have them neatly sorted by date on my Bar Chart Visual. Any tips on how to make this happen would be awesome! Here's what I did:

1. I made a date table and linked it to my main table.
2. In my Bar Chart Visual, I drag in the date column from my date table.

I've got some screenshots of both tables and the model connection. Can you take a peek and help me out? Thanks a bunch!

date tablemain table
model connection

Need Help
Tips and Tricks
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi janinedev 
    According to the picture, the relationship is many to many, 
    Check duplicates in your date table :

    You have to have a schema similar to mine :

    I attached my pbix to let you follow if it doesn't help.
    Please share the link to your dummy file.

     

    If this post helps, then please consider Accepting it as the solution to help the other

    members find it more quickly

  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi janinedev 

    The relationship still does not seem the same relationship...

    And as I mentioned in my previous post, Please share the link to your dummy file.

5 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    2 years ago

    Hi janinedev 
    According to the picture, the relationship is many to many, 
    Check duplicates in your date table :

    You have to have a schema similar to mine :

    I attached my pbix to let you follow if it doesn't help.
    Please share the link to your dummy file.

     

    If this post helps, then please consider Accepting it as the solution to help the other

    members find it more quickly

    • janinedev's avatar
      janinedev
      Frequent Visitor
      2 years ago

      Thank you for your help Ritaf1983 , So I changed the model connection but it's still not showing the visual.
      so here's the new screenshot. 

       

       

      • Ritaf1983's avatar
        Ritaf1983
        Super User
        2 years ago

        Hi janinedev 

        The relationship still does not seem the same relationship...

        And as I mentioned in my previous post, Please share the link to your dummy file.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Click the value on your Y-axis, and in the ribbon, you will see the 'Columns' tools. There is an option to sort by; select the column that you want to be sorted.