Forum Discussion

tlee's avatar
tlee
Regular Visitor
6 years ago
Solved

Line graphs show straight line and dates

Hello Everyone, I could use some help please.  I've attached a screenshot that shows how all of the lines are fixed, as well as on one of the graphs the date range extends into the future.  Can you ...
Date
line graph
straight line
  • tlee's avatar
    tlee
    6 years ago

    Hi Josef,

     

    I think I figured out the blank chart issue.  I was drawing the slicer names from a table in access but the date type was "number".  I changed a few things and the data type is "short text" now and it seems to work.

     

    Thank you for all of your time!

    Tammy

JosefPrakljacic's avatar
JosefPrakljacic
Icon for Solution Sage rankSolution Sage
6 years ago

Hey tlee,

 

could you please tell me more about the relationship between the tables which columns are you joining?

 

BR,

Josef

tlee's avatar
tlee
Regular Visitor
6 years ago

Hi Josef,

Yes please see the relationships below.

I have Dates coming from the date table

and Properties coming from the Propeprty Info table

 

I am trying to graph actual vs budgeted Revenue, and Income and related measures for Revenue and Income on the line graphs.

 

Thank you!

Tammy

  • JosefPrakljacic's avatar
    JosefPrakljacic
    Icon for Solution Sage rankSolution Sage
    6 years ago
    Hello,
    what if you change the relationships here to Cross Filter?
     
     
    Without a sample report, this is still pure guessing on my side.
    BR,
    Josef
    • tlee's avatar
      tlee
      Regular Visitor
      6 years ago

      Thanks for keeping at this with me.  I started a new Power BI file and get the same result.  Curious though that when "Blank" is selected in the slicer the lines appear, but when I choose to slice it then both lines disappear.  I'm sorry, I don't know how to share this without violating work confidentiality rules.  I really appreciate all your help with this!

      • tlee's avatar
        tlee
        Regular Visitor
        6 years ago

        Hi Josef,

         

        I think I figured out the blank chart issue.  I was drawing the slicer names from a table in access but the date type was "number".  I changed a few things and the data type is "short text" now and it seems to work.

         

        Thank you for all of your time!

        Tammy