Forum Discussion
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.
Below is table when i filter on a country:
see the matrix below without filtering on 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
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
6 Replies
v-xiaotangCommunity Support
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.
- Ashish_Mathur
Super User
Hi,
Try this measure
=coalesce(average(consolidated[avg_spend]),0)
Hope this helps.
Tahreem24Anonymous, if you want to ignore Country slicer so try "Edit Interaction" feature.
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
- amitchandak
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
Hi Anonymous
Have you solved this problem? If yes, could you kindly accept the answer helpful as the solution (or kindly share your solution ). so the others can find it more quickly.
really appreciate!
Any question, please let me know. Looking forward to receiving your reply.
Best Regards,
Community Support Team _Tang
