Forum Discussion
Select Data based on slicer selection
Hi everyone, This has been doing my head in for a while and I wonder if I could get some advice. I have 5 Data sets, each sharing the same columns but have different values based on a Type of...
Are you able to union the datasets in PowerQuery (since they share the same column names). Then you can simply create the report as usual using the UnionedTable, and put a slicer in to select the company.
I'm not sure about the details of your report, but you can use a slicer with the single-select option to make sure that you won't have to do any extra code to handle the case where nothing is selected.