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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here
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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here
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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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