Forum Discussion

truch2's avatar
truch2
Frequent Visitor
9 years ago

Display sliced data in a different chart

Hi. I'm relativley new to powerbi, and have run into an issue I can't seem to solve. The snapshot below shows three columns of data "Company name", "Store name", and "Product sold". I uploaded this t...
Need Help
truch2's avatar
truch2
Frequent Visitor
9 years ago

Thanks for the reply! I've tried a couple of variations on the method you linked to. The issue is with the first measure:

 

 = IF(HASONEFILTER(table[column]), VALUES(table[column]), BLANK())

 

This produces a scalar result, so if you have two options selected it returns a blank instead of both values. An argument like this would be perfect if there was a "RETURN ALL FILTERED ITEMS" command. 

 

I've tried creating a new column using that type of argument, but no dice. Basically, I need a way to take the info from a sliced column in one table, and use it to inform the filtering on another table.