Forum Discussion
Slicer filtering incorrect
Hi Anonymous
Q1. How do I move my dates to parent table, the date section is available in child table only, in the earlier instance I had rated non rated in parent table hence was able to filter.
A. Given the structure has changed, I can only advise on what I'd do. I would find the primary key / unique identifier and create a calculated column that uses LOOKUPVALUE.
Calc Column = LOOKUPVALUE ( ChildTable[Date Column] , ChildTable[Primary Key Column] , Parent Table [Primary Key Column] )Q2. Apologies mate, I meant to write CY9 instead of CY10, (So, CY9> Not Rated> Gas >C,F,I) Contract year is a conditional column added acc to audit dates in child table.
A. Sweet.
Q3. For count of unrated, it shows 4 line item in the table after filtering but shows 0 in the card below, wanting the data to show 5 when rated and 4 when unrated (B,E,J,L), H shouldn't be there because H's category is Service not Gas.
A. Factors that could be causing this is that you do not have a Service Type Filter that removes Service and only has Gas ticked. It could be because the measure / count is not a distinct count on the OtherParticipants column. There are many factors unfortunately but those two are the most likely.
Hope this helps!
Cheers mate!
Theo
TheoC amitchandak, any help would be appreciated, thanks.
Hi Anonymous
No worries at all:
- In terms of your comment regarding adding a column for Audit Date, the reason it is filtering down to "Rated" is because the Child table only has Rated. Therefore, Power BI is filtering the visual table based on the logic that there is no Not Rated in the Child table (so it's doing what you're asking it to do basically). Remember the previous solution how you had to use the Rated / Not Rated from the Parent table as the filter? It's a similar approach here.
- Regarding your Contract Year Slicer, the data that you have presented in the post suggests that C, F, I are all Rated. Also, where did you get the Contract Year data from to use as a filter?
- In terms of the count of Not Rated being 4 in the visual, that's not the same as the data you have posted in your post. In your post, the count of Not Rated is 5, being B, E, H, J and L.
More than happy to assist further. Just do me a favour and make sure that the sample data you're posting aligns to the sample data in the dashboard you're presenting so that we are speaking the same data (little change up on the "speaking the same language" lol!).
Let me know how you go above!
TheoAlright TheoC
a. How do I move my dates to parent table, the date section is available in child table only, in the earlier instance I had rated non rated in parent table hence was able to filter.
b. Apologies mate, I meant to write CY9 instead of CY10, (So, CY9> Not Rated> Gas >C,F,I) Contract year is a conditional column added acc to audit dates in child table
c. For count of unrated, it shows 4 line item in the table after filtering but shows 0 in the card below, wanting the data to show 5 when rated and 4 when unrated (B,E,J,L), H shouldn't be there because H's category is Service not Gas.
If you need more details, let me know.
TheoC Hi Theo, can you help me with this? it's a key component that's broken for me to finish this assignment.