Forum Discussion

Cr7vc's avatar
Cr7vc
New Member
3 years ago

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 "circ...
Need Help
Tips and Tricks
lucadelicio's avatar
lucadelicio
Impactful Individual
3 years ago

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
Id

Parametric 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!

  • lucadelicio's avatar
    lucadelicio
    Impactful Individual
    3 years ago

    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!