Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Matrix Table Showing Q3 and Q4 even if there's no data after June

Hi all,

My dates table starts from 1/1/2018 and ends at 30/6/2018. So, I only have Q1 and Q2.""

In matrix table whenever I put my dates column (Auto detection is on) I get 2018 and when I drill down I see Q1,Q2, Q3 and Q4 in my columns. Of course, the only amount thats populated is Q1 and Q2, but I'm confused as to why Q3 and Q4 is even there with everything blank

I fixed the issue by creating a date hierarchy myself. However, I'm very curious as to why Q3 and Q4 is populating in my matrix table because my colleague did the same auto detection function and pulled the dates column from dates table to matrix table column field, but he didn't get Q3 and Q4.

Thank you



1 ACCEPTED SOLUTION

Hi @Anonymous ,

It seems that these two screenshots are exactly the same... When you enable the Auto date/time option, a auto date/time table be created. The auto date/time table contains full calendar years encompassing all date values stored in the model date column. For example, the earliest value in a date column is Jan 1, 2018 and the latest value is June 30, 2018 in your dates table, the table will include all dates of a full calendar year 2018. You can find the details in this official documentation.

In addition, please check with your colleague whether he/she disable the Show items with no data feature for the related visual.

Show items with no data.JPG

Best Regards

Rena

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

7 REPLIES 7
amitchandak
Super User
Super User

@Anonymous , I think this because you are using the default Date Hierarchy, which comes with a date.

 

Create Qtr, Month, year in date table and create custom Hierarchy

Anonymous
Not applicable

Yup, I did that and fixed it already. But the thing is it shouldn't be populating even if I put default date hierarchy. It's probably a setting issue and I'm really curious as to why

its almost impossible to see that screen shot lol.

i think it has to do with the fact that it will automatically create dates for the whole year for the year you have data in, thats why its better to use your own date table if you want to manage the behaviour




If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Anonymous
Not applicable

My Visual

shekhar_123_1-1600843774651.png


My Colleagues Visual

shekhar_123_2-1600843784259.png


Everything is the same, even he used the autodetected date hierarchy from dates table but he isn't getting Q3 & Q4 but I am getting Q3 and Q4. Our dates table doesn't even have data after June.

Thankyou

 

Hi @Anonymous ,

It seems that these two screenshots are exactly the same... When you enable the Auto date/time option, a auto date/time table be created. The auto date/time table contains full calendar years encompassing all date values stored in the model date column. For example, the earliest value in a date column is Jan 1, 2018 and the latest value is June 30, 2018 in your dates table, the table will include all dates of a full calendar year 2018. You can find the details in this official documentation.

In addition, please check with your colleague whether he/she disable the Show items with no data feature for the related visual.

Show items with no data.JPG

Best Regards

Rena

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
vanessafvg
Super User
Super User

it would be quite difficult to know without looking at what you are both doing differently. Is your power bi file exactly the same? can you provide some screenshots?




If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Anonymous
Not applicable

shekhar_123_0-1600842607655.png

Hi,

here it is 🙂

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.