HI thx for the tips very usefull! Question: I have a slicer with dimension values, lets say a list of regions, that are an inactive connection to a main table. What I want to do is to remove from the slicer list the values that dont have any sales, on a normal active connection table you do this buy adding to the visual filter the sales value and filter by is not blank and is not zero. on and Unactice connection this dontsent work. how can I remove this empty return values from he selection??
Hi Mathy, It's a bit difficult to give recommendation without looking at the data structure, model and working of the PBIX file for the reference. You can reach out to us on our Community Forum by providing a detailed description of your query along with relevant files for reference. Our members and team of Experts will be happy to help out! If you haven't yet, do subscribe to our RU-vid channel and LinkedIn group to keep posted on Power BI, Power Platform, and the Microsoft stack updates. Hoping you find this useful! Cheers, Enterprise DNA forum.enterprisedna.co/ www.linkedin.com/groups/12004506/