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.
Hello,
In my report, I have a table visual which is generated by using columns from different tables. I applied some filters on the table visual by writing a calculated column where I am comparing two prices and flagging them 1 or 0 where the prices are not same and filtering the table visual where this calculated column value is 1. Now, I need to add a slicer on some columns of this table visual. But the problem is, I am not able to reflect the filtered values only into the slicer. It shows all the values. How can I achieve this, to show values only from the filtered table? I applied page level filter, but it is not working? It is showing empty.
Thank you
it seems a relationship is missing between the tables. try to connect tables on columns and take the columns from the one side of the relationship to the visual, e.g. slicer.
User | Count |
---|---|
25 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
28 | |
13 | |
12 | |
12 | |
6 |