We're giving away 30 tickets for FREE! Share your story, your vision, or your hustle and tell us why YOU deserve a ticket.
Apply nowWin a FREE 3 Day Ticket to FabCon Vienna. Apply now
Data value missing in Slicer.
Below "Type" "Category" "Detail" pulled from same table "Master Category", except "Date" was pulled from Calendar table
When i select like below, Value "C" and "F" and "G" had gone missing from Slicer "Detail", you can see from the table on the left, those 3 values exist. Any1 know why?
The relationship is as below, 3 tables were connected to a "Master Category" table which those slicers pulled from. And all the dates from those 3 tables were connected to the "Calendar date"
Solved! Go to Solution.
Try setting the relationship between Mater Category and Data -AD from bidirectional to single.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Which tables are "c" "f" & "g" from? I think @ImkeF is right; it's a relationship issue between the tables.
Try setting the relationship between Mater Category and Data -AD from bidirectional to single.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
@ImkeFoh yes, it works, why this one is "both" rest all "single", wired. thanks!!
User | Count |
---|---|
67 | |
61 | |
47 | |
35 | |
32 |
User | Count |
---|---|
87 | |
72 | |
57 | |
51 | |
45 |