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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Dates On Fact Table - required in table visual - unhide the fact table columns to be reported upon?

Hi , basically this question is do I expose the fact table columsn to be used in reports - the general advice is hideteh fact table?

 

 

ID Date CompletedDate ArrivedQuantityBusiness Key
131/01/200001/01/20006A
228/01/200003/01/20007B
314/01/200004/01/20008C
409/01/200001/02/20009D

 

I have relationships to the two date columns to a date table.

 

Say if I wanted a list of those arriving in Feb I simply want the line four in table visual.

 

If i have hidden the fact table - how do I get these columns , I cant use related to the calendar, because it has more than one relationship?

 

So should i just be using the fact table date columns? How woudl i do this if I was using an integer date key?

Similarly I have a business key - which isnt in any dimension?

 

Hope you understand the question. Any reading on this subject would be most welcome. Thanks

 

 

4 REPLIES 4
amitchandak
Super User
Super User

@Anonymous , Not very clear. for two dates, one active and one inactive you can use userelationship to enable

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi

Anonymous
Not applicable

Hi , i just want to know if I should use the columns in the fact table for the colums in my visual table, as one one the dates is connected via a inactive relationship.

I know how to use userelationship.

 

Using the fact column goes against the general advice of hiding the fact table? Thanks

@Anonymous , We should hide keys from the fact not all columns. I really not sure why you want to hide the complete fact. In any case, a measure/ column used in visual should continue to work

Anonymous
Not applicable

Thanks Amit in this case the dates are the FKS? What if they were integers FKS to a date table - how would I then get the multiple dates on an inactive relationships into a table visual?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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