Forum Discussion

tich11's avatar
tich11
Frequent Visitor
3 years ago
Solved

Group similar columns into new fields in a table visualisation

Hello,   I am very new to Power BI and struggling to work out how to resolve this.   I have a table where the first column is the unique value controlling the slicer. I then want this to control ...
Need Help
  • lucadelicio's avatar
    lucadelicio
    3 years ago

    You have to work it on your dataset.
    Here the pbix (change the path on the power query mode).
    https://we.tl/t-xq3GTV6m2e
    You have to create a table like this:
    UPR - TYPE - REF. - ADDRESS
    To do this from your data you have to create a 3 intermidiate table (that u don't import in the model) and than use to append (union) each other and create your final fact table.

    A Dimension is use to create a table of single value use to filter with very good performance.

    Create your star schema with the correct relationship.

    I hope I have been helpful.
    Mark it as a solution if resolve your problem.

    Ciao!