1 Tab multiple facts

[ADVJ27]

Hello

I have 3 fact in my model

I would like to create a tab visualisation with 1 column from each fact .

It's not working. 

How can I do that ?

Any vidéos, ressources ,tutorial with similar case will be helpful

[Idrissshatila]

Hello @ADVJ27 ,

you need to build your data model as a star schema where the common fields between the 3 fact tables will be in dimension tables that are then linked into the fact table.in this way you can the display fields from different tables along with the field in the dimension table that is linked to them.

check this to learn the concept of star schema data modeling 

https://youtu.be/7ciFtfi-kQs?si=o2ap7u9D1QPf64uC

[Ritaf1983]

Hi @ADVJ27 
You need to create connections between those facts with dim tables by common fields.
Please refer to the linked tutorials:

https://www.youtube.com/watch?v=TnyRsO4NJPc

https://www.youtube.com/watch?v=FMR4ZAWjvBE

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly