Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Team,
I have come across an issue where I couldnt able to resolve . I have explained the problem in detail .Please look into it and help me in resolving the issue.
I have two tables in Report page as shown in screen shot . Also I have 2 slicers based on Attributes and Values columns in Query . If I select "Hardware Management controller" as a value in Slicer ,it is showing data in one table and an empty records in other table which is absolutely correct. However, Once I select some value in other slicer(Value) , it should select values in respective table and associated values in other table. I couldnt able to edit the interactions in the required way. Please help me in fixing this issue.
How I want is ? It is not happening because this is just one query .
Hi @Anonymous ,
Normally, if you filtered with two slicer, the result will be the filtered value based on the two slicers. So when you select "Hardware Management controller" as a value in Slicer, it will show the value based on this selection, when you select another option in Value slicer, it will be filtered the value based on your first selection.
I have a little confused about your scenario.
So what is your desired output for slicers? If it is convenient, could you share the data model which could reproduce your scenario and your desired output so that we could help further on it?
Best Regards,
Cherry
Hi Cherry,
Thanks for replying . I have attached the data model of my report . In each of those 3 main tables on top(HMC,Managed Systems and Servers/LAPRs) , Columns called Value and Attribute are combined from this 3 tables and used as a slicers . 2 tables are created using a DAX formulae to combine them . See below .
Can some one help me on this please ?
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |