Forum Discussion
Powerbi Component not showing data properly
I think i have figured it out.
I have a Date filter affecting all the components of the report. It has the option to select "All dates" and an option to select a custom period.The issue is related to this behavior :
When i select a custom period and go back the All Dates, the custom dates are not reset properly so the categories are affected by this since they depend on the products included in the date interval.
The behavior was mainly in prod because the report was saved with this behaviour so when i used the reset filters button it went back to this, whereas in the other environments no custom dates were set.Thanks for all the help !
Hi rmartini ,
Thank you for reaching out to the Microsoft Community Forum.
Please try below things to fix the issue.
1. Reset report state in PROD: Power BI Service --> Open report --> View --> Reset to default. Clear personal bookmarks and re-check any shared/default bookmarks.
2. Select the Category slicer --> Format pane --> Slicer settings --> Options --> Show items with no data --> On.
This forces the slicer to show all categories from the dimension even if the fact is filtered down.
3. Verify relationship direction: Model view --> Relationship Category <--> Bookings should be Single direction from Category to Bookings. Turn OFF “Apply security filter in both directions”.
4. Check Sync Slicers: View --> Sync slicers --> Ensure Category is not synced to a page with a single saved selection.
5. Remove implicit filters restricting Bookings/Category.
6. Edit Interactions: Make sure other visuals don’t filter your Category slicer, you can set them to None for that slicer.
I hope this information helps. Please do let us know if you have any further queries.
Regards,
Dinesh
Hi rmartini ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.
Regards,
Dinesh
I think i have figured it out.
I have a Date filter affecting all the components of the report. It has the option to select "All dates" and an option to select a custom period.The issue is related to this behavior :
When i select a custom period and go back the All Dates, the custom dates are not reset properly so the categories are affected by this since they depend on the products included in the date interval.
The behavior was mainly in prod because the report was saved with this behaviour so when i used the reset filters button it went back to this, whereas in the other environments no custom dates were set.Thanks for all the help !