The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
i noticed some problem with filtering Table and Matrix visuals.
I have sorted table by specific column. If I filter a table with value A everything is all right... it shows sorted data, start with the highest value.
But if I add in filter value B (so i have now two values in filter A and B), table is filtered corretly, but first value isn't the highest one. I have to scroll up, to se the highest value.
Is this issue known? Is there a way to resolve it?
In pictures:
Filter A:
If i add filter B to A it still shows 702 as first number:
But it shold show like that:
Thank you so much for answers and possible solutions.
@matemusic,
Could you please share dummy data of your table and describe that what fields you use to create the table/matrix visual? Also we need to know that the specific column that you use to sort the visual.
Regards,
Lydia
I have the same problem. Here is the problem in pictures:
We have simple data:
And then we do the table (left) and slicer (right)
@spelap @matemusic,
When selecting multiple values in slicer, your current table visual is not large enough to display all the values, thus it requires to move scrolling to see highest value.
In order to see the highest value after filtering, please enlarge your table visual.
Regards,
Lydia
Hi @Anonymous,
thank you for your response. Unfortunately enlarging a table visual is not resolving this problem. We can have more hundreds rows, so we can't enlarge table visual that much. In addition we have other visuals on report, so there is also not enough space.
Regards,
Matej