Forum Discussion
Columns based on filters
I have a dataset containing 18 columns I want to create a table and show values based on filter on source column if source is "web" display certain set of columns(source, amt,qty) if source is "circular" then display source , to date, from date, quantity, cess amount. How to achieve this please advise
4 Replies
Create a field parameter. With this operation you would see appear a new table.
In this table create a new column (with the id) and connect it in the relationship you would to choose your value.
The table is rapresent like this:
Description
Fields
Order Fields
IdParametric Table = {("NameField1", NAMEOF('Table'[Field1]), 0, "ID_01")
("NameField2", NAMEOF('Table'[Field2]), 1, "ID_01"),("NameField2", NAMEOF('Table'[Field2]), 0, "ID_02"),("NameField3", NAMEOF('Table'[Field3]), 1, "ID_02")}
Put the Description (or Fields i don't remember) into table to show your result.
If you want more support please upload the pbix file.
If i resolve your problem please mark it as a solution.
Ciao!Please find the path to pbix file:
https://drive.google.com/file/d/1aFlk36qqUprp5zf5YIg9Bn9FK-5YK0_3/view?usp=drivesdk
Here the link with the pbix file.
https://we.tl/t-bZFV2cqHtR
You can't hide the column without value.
If you select a column for choice you'll see it.
I hope I have been helpful.
Mark it as a solution if resolve your problem.Ciao!
Please find the attached path to pbix file with sample data.
https://drive.google.com/file/d/1aFlk36qqUprp5zf5YIg9Bn9FK-5YK0_3/view?usp=drivesdk
