Forum Discussion
Solved
How to set column as a data field depending on selected Filter
I want to show a visual object with a column dependence depending on the selected filter.
The datatables are these:
| Product | Import | ImportEur | ImportUSD |
| 1 | 11 | 12 | 10 |
| 2 | 11 | 12 | 10 |
| 3 | 12 | 13 | 11 |
| 4 | 12 | 13 | 11 |
| 5 | 13 | 14 | 12 |
| Badge |
| Local |
| Eur |
| Usd |
The filter I have created depends on badge column. What I want is a visual object that shows the product and depending on the filter shows the import if is Local, importEUR if is EUR and importUSD if is USD.
Hi,
There are multiple ways of doing this.
This is one:
4 Replies
ryan_mayuSuper User
maybe you can try to select product and unpivot other columns in PQ.
then you can just filter attribute column
The problem is that the table not have only the column product, it have 20 columns more...
- ryan_mayu
what about select import , importEUR and import USD then unpivot columns?
NickolajJessenSolution Sage
Hi,
There are multiple ways of doing this.
This is one:
