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 having country column and other two are not. I have one slicer called Country. 

 

i want the Items to ignor the country slicer... I want to have below table when filter on Country.

 

 

I have tried REMOVEFILTERS(), ALL(), ALLSELECTED() in Measure but did not get desired output.

Best Regards and Thanks for your help...!

Khan

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    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