Forum Discussion

rruthSL's avatar
rruthSL
Icon for Advocate I rankAdvocate I
1 year ago
Solved

Slicer and Table Missing Values Despite Matrix Showing All – Calendar Relationship Issue in Power BI

  Problem Description I have a Power BI report where: A matrix shows resources in the rows along with a measure in the values. A slicer is built on the same Resource field. Certain resourc...
Need Help
  • Deku's avatar
    Deku
    1 year ago

    Edit the interactions so the other slicers do not affect that slicer. Measures can make fields show in tables that would otherwise not be visual in the context. If you remove the measures from the visual you will likely see on 7 rather than 9

Deku's avatar
Deku
Icon for Super User rankSuper User
1 year ago

Edit the interactions so the other slicers do not affect that slicer. Measures can make fields show in tables that would otherwise not be visual in the context. If you remove the measures from the visual you will likely see on 7 rather than 9

rruthSL's avatar
rruthSL
Icon for Advocate I rankAdvocate I
1 year ago

Yes, if I remove the measures, I am back down to 7 resources (Which is not what I would expect, I expect all 9 resrouces in the dataset to be visualized). I've removed interactions and the same behavior persists.

  • Deku's avatar
    Deku
    Icon for Super User rankSuper User
    1 year ago

    There must be a residual filter coming from somewhere

    • rruthSL's avatar
      rruthSL
      Icon for Advocate I rankAdvocate I
      1 year ago

      Per your guidance, I turned off most all the interactions between the slicers on the page. This seemed to give me all 9 resrouces in my slicer. Thank you!