Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have an installation with power bi on-premises and office online server also on-premises, both with the latest version. I have uploaded to power bi an excel workbook that includes a pivotable with two slicers and all working good. I have the below request and i need some help with this
"When a user sees the excel workbook from power bi server and office online a parameter value should be passed to filter the slicer inside workbook, the parameter value changes based on the user that sees the workbook. My problem is that i can't find a way to pass the parameter value inside excel. I know that with sharepoint and web parts is working, but in my case is not an option to install sharepoint, also i have tried to use power bi syntax for filter ?filter=table/column eq 'some value' but doesn't work either.
User | Count |
---|---|
15 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
18 | |
11 | |
5 | |
4 | |
3 |