Skip to main content
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.

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


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



Super User
Super User

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

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

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

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


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.