Skip to main content

Notifications

Power Up Program - Visualize data with Power BI
Answered

School Year/Month Data Disappearing

Posted on 15 Apr 2024 16:38:02 by 53

When I created a relationship between date loan start and date, the data from the school year and month disappeared from my matrix graph. Does anyone know why or how to fix it? I've tried deleting and recreating both the relationship and the graph, but still the same issue.

 

Categories:
  • CU14101411-0 Profile Picture
    CU14101411-0 2 on 11 Nov 2024 at 15:03:46
    School Year/Month Data Disappearing
    Thank you! it worked.
     
  • ZK-04102010-0 Profile Picture
    ZK-04102010-0 8 on 30 Oct 2024 at 17:51:09
    School Year/Month Data Disappearing
    Thank you soo much , that was really helpful....you just saved my day!!!!
  • tswatkins75 Profile Picture
    tswatkins75 4 on 09 Jul 2024 at 23:52:01
    Re: School Year/Month Data Disappearing

    Thank you so much!!! This solved my issue.

  • TQPower Profile Picture
    TQPower 4 on 07 Jul 2024 at 21:59:45
    Re: School Year/Month Data Disappearing

    ahhhhhhhhhhh at last resolved. Figured out my mistake. 

    Thank you so much for the solution. Lesson learnt! 

  • TQPower Profile Picture
    TQPower 4 on 07 Jul 2024 at 21:45:34
    Re: School Year/Month Data Disappearing

    I followed everything and reviewed several times. Still unable to see the desirable result. I am wondering why almost everyone facing the problem resolved it where I am still struggling 😞

  • MichaelVaughan Profile Picture
    MichaelVaughan 31 on 01 Jul 2024 at 22:03:48
    Re: School Year/Month Data Disappearing

    I just wanted to drop you a quick note to say that this worked for me! Thanks a bunch for your help, I really appreciate it!

  • TLofton Profile Picture
    TLofton 2 on 30 Jun 2024 at 03:41:29
    Re: School Year/Month Data Disappearing

    Thank you so much. change date to short on the Table view for DimDate then clicking the three dots ... next to loans table in the table view then click edit query then change date column pu_loanstartdate to date then to short then click close and apply. worked like a charm...  thank you.. thank you.. thank you..  side note: don't forget to also right clicked the items in your rows pane of my visuals to show items with no data

    TLofton_0-1719718873218.png

     

  • Natalia5 Profile Picture
    Natalia5 5 on 28 Jun 2024 at 20:25:54
    Re: School Year/Month Data Disappearing

    Thank you so much for sharing. I tried going back to redo it as I was sure I was doing something wrong, when it failed again I looked here and was very grateful to find your solution. 

  • FranFlow78 Profile Picture
    FranFlow78 40 on 28 Jun 2024 at 13:02:45
    Re: School Year/Month Data Disappearing

    That worked for me too! I wonder if I will ever be able to help peoples as much as you just did!

  • reem-elmorsy Profile Picture
    reem-elmorsy 33 on 25 Jun 2024 at 21:41:50
    Re: School Year/Month Data Disappearing

    Thank you

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,151

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,845

Leaderboard

Featured topics