Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

display all Dimension items in Matrix

Hi everybody,  I am currently facing issue to show all Items(Items is my dimension) in  matrix visual.  I have one table generated by APPENDING five excel files in power BI, three excel files havin...
Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , I such case it is better to have independent date table, because they way filter behaves in power bi

     

    refer

    Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE

v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous 

try this,

1. create an independent table Country

 

Country = SUMMARIZE(Consolidated,Consolidated[Source Country])

 

2. put Country[Source Country] into slicer instead of Consolidated[Source Country]

 

 

 

Best Regards,

Community Support Team _Tang

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