Forum Discussion

SearchKnowledge's avatar
SearchKnowledge
Icon for Helper I rankHelper I
5 years ago
Solved

Combine values from visuals into a total visual

Hello kind reader,   The situation is like this: I have two table visuals: Bothe tables contain different columns and different date filters, however they have 1 column which is the same: The prod...
Need Help
  • SearchKnowledge's avatar
    SearchKnowledge
    5 years ago

    mahoneypat Anonymous 
    I have found a solution: It was to put the function ALL('Date') into the measures i didnt want to be affected by the slicer. And then with Daterange() i could set the static date range. 

    Thanks you all for thinking with me!

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi SearchKnowledge 

I think you want to filter two tables firstly and then append two tables to get a new table.

Do you want to build a calculated table? You can try slicer and union to get the result by dax.

Or you can try parameter and append to get result by Power Query.

However you can't get a dynamic table filtered by slicer or parameter.

If this reply still couldn't help you solve your problem, please share a sample with me by your Onedrive for Business. And you can show me a screenshot of the result you want.

 

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.