Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have a matrix visual that uses a data table built with a SummarizeColumns command.
BudgetPivot =
SummarizeColumns('Budget'[Budget Line],'Budget'[Funding Category],'Budget'[FY],'Budget'[SlotConv],'Budget'[Dashboard],'Budget'[Funding],'Budget'[IT Category],'Budget'[Contract Name],'Budget'[DashFund],'Budget'[Cost],'Budget'[Time Category])
The filter icon for the visual shows it is filtered using a combination of page filters, slicers, and filters set on the visual itself, and if I look at the data table directly and filter by those filters, the data is correct. However, when I look at the visual, the second-level rows within the visual are not filtered by anything except the filters applied to the visual itself. It is ignoring the page and slicer filters. I've checked to confirm that the visual is set to "keep all filters" and that the slicer interactions do include that visual. This all worked a few weeks ago. I've been on vacation, so I'm not sure exactly when it stopped working, but I haven't made any changes, and now it doesn't work. This image shows the visual without the correct filtering on top, and on bottom it shows what it would look like if the filters were filtering correctly. Note that the list of filters and slicers affecting the visual lists all the filters, so they are supposed to be getting applied, but they are not. (I put the relevant filters on the bottom visual directly to make them work so I could show what it should be; otherwise, that visual doesn't filter correctly either.)
@Microsoft I think this might be a bug, and I tried to submit a support ticket, but I don't see how to submit one for PowerBI - the page to submit tickets in Fabric didn't list Power BI in the required field dropdown list of products.
@Sarah_Lanning , if you have created a calculated table using DAX, then it will not take any filter of slicer values. It needs to be joined back with common dimension to filter the values.
calculated table and columns are static in nature and do changes with filter and slicer values (In Data table)
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
86 | |
79 | |
53 | |
39 | |
39 |
User | Count |
---|---|
104 | |
85 | |
47 | |
44 | |
43 |