visual not updating when applying slicer

[Charlie_Dougan]

Hi, new here so apologies of this has been covered before. 

I have created a very basic visual that is summing up totals of total product made along with failed and the reason for failure and total tonnage of any faulire. I have applied slicers to view different product types. on some slicers the sums and totals work fine. on others while the filter works the totals do not change to reflect only that which i have selected. 

I think it is because one of the product catagories is from a seperate table and i have tried to create a relationship bewtween the two tables, but i dont know how to resolve. 

there is a heriacrhy involved too main product (on seperate sheet) and sub products (on main sheet). the slicer is working for the sub product, but when i apply a slicer to the the main product my totals are unchanged. apologies if this is clumsy as i am still new to power BI

thanks

Charlie

[Ashish_Mathur]

Hi,

You should create a seperate Product table (Dim table).  Create a Many to One relationship from the Fact table to this Dim table.  To your visual, drag Product from the Product Dim table.

[Anonymous]

Hi @Charlie_Dougan ,

Yes, I did try to reproduce what you stated.

But I realized that I don't know exactly what form your tabular data is in.

Or if you can provide me the data in the form.

Please provide the relevant example data and the specific .pbix file if you can.

Best Regards

Yilong Zhou

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

[saud968]

No worries, you’re doing great for someone new to Power BI! It sounds like the issue might be related to the relationships between your tables and how the hierarchy is set up. Here are a few steps you can take to troubleshoot and resolve this:

Check Relationships: Ensure that the relationship between the tables is correctly set up. Go to the “Model” view and verify that the relationship between the main product table and the sub-product table is active and correctly defined (e.g., one-to-many or many-to-one).
Cross-Filtering: Make sure that the cross-filter direction is set correctly. In the relationship settings, you can choose the cross-filter direction (single or both). For your scenario, setting it to “Both” might help.
Hierarchy Setup: Verify that the hierarchy is correctly defined. Ensure that the main product and sub-product are part of the same hierarchy. You can do this by creating a hierarchy in the “Fields” pane and adding both the main product and sub-product fields to it.
Slicer Settings: Check the settings of your slicers. Ensure that they are set to filter the data correctly. Sometimes, slicers can be set to “Single Select” or “Multi-Select” which might affect how they filter the data.
Measure Calculation: If you are using measures to calculate totals, ensure that the measures are correctly defined to account for the filters applied by the slicers. You might need to use DAX functions like CALCULATE to ensure the measures respect the slicers.
Data Refresh: Sometimes, simply refreshing the data model can resolve issues. Make sure to refresh your data after making changes to relationships or slicers.
If you still face issues, feel free to share more details or screenshots, and we can help you further.

Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!