How make Dimension Tables from 3 different tables for slicers in Power BI

[Anonymous]

Hi, can anybody tell me how to get 1 dimension table from 3 different tables for slicers.

For example I have following data model:

In this model I am common datasourceid, Date and Area columns and want to slice the measure tables from these columns.

[selimovd · Accepted solution]

Hey @Anonymous ,

for each dimension you have to create a dimensional table in Power Query. For the date you could also in Power BI with a DAX table (I would even recommend that), but the rest in Power Query.

For the dimensional tables you have to get all unique values, for example all datasourceids. So append the datasourceid column from all tables into one and remove all the duplicates. Then you have a dimensional table and can filter all fact tables.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic