Forum Discussion

jc508's avatar
jc508
Frequent Visitor
10 years ago

Restricting dimensions to used values

Hi, I am using Power BI over an SSAS Tabular model. We have several generic dimensions, like Nationality, which usually come from standardised data sets and have many entries. Any particular fact ...
Tips and Tricks
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
10 years ago

Hi jc508,

 

Actually, you can create a dataset storing nationalities in PowerBI and create relationship between your data. Then use this as Slicer. Try it and let me know if it helps.

  • jc508's avatar
    jc508
    Frequent Visitor
    9 years ago

    Sam,

    thanks for the thought and sorry for the delayed response (I actually got some holidays!)

     

    I think your idea kind of hurts the idea of shared / conformed dimensions especially when they come from external sources.

     

    JC