how to get the column name in slicer

[Anonymous]

HI,

How to get the column names in slicer. Filtering 1 or more column names based on the need.

[Icey]

Hi @Anonymous ,

Just like what @Anonymous  said, Power BI doesn't support to select columns using slicer. What's your purpose? Maybe I can provide you with other workarounds.

Best Regards,

Icey

[Anonymous]

Hi @Icey ,

yes. I need to get the measure names in filter.

I have tried the below formula, but the data is not showing up. When i use the data directly without using formula the data is showing in chart type. Let me know the alternate method if anything available.

when i use the data directly instead of formula

[Icey]

Hi @Anonymous ,

Try this:

Measure =
IF (
    SELECTEDVALUE ( Table[column] ) = "Net Sales (RS mn)",
    [SUM NET_SALES],
    IF (
        SELECTEDVALUE ( Table[column] ) = "Net Sales Gth(%)",
        [NET_SALES GTH (%)],
        IF (
            SELECTEDVALUE ( Table[column] ) = "EBITDA (RS mn)",
            [SUM EBITDA],
            IF (
                SELECTEDVALUE ( Table[column] ) = "EBITDA (%)",
                [EBITDA_GTH (%)],
                BLANK ()
            )
        )
    )
)

Keep 'Table' and 'Join BI...' independent of each other.

Best Regards,
Icey

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

[Anonymous]

Still i am not able to see the data in chart or table.

Let me know how can i share my .pbix file. bcoz i am not able to see the attachment option.

Table is independent

[Icey]

Hi @Anonymous ,

You can share your PBIX file without privacy information by OneDrive for Business. And attach the link.

Best Regards,

Icey

[Anonymous]

https://drive.google.com/file/d/19DgsnnFxDDBDQIM-5tJLj_3hSYDC3nz0/view?usp=drivesdk

[Anonymous]

@Icey  . Whether the link is opening or not. so that i can share another link

[Icey · Accepted solution]

Hi @Anonymous ,

Try this:

Measure Selection1 = 
IF (
    SELECTEDVALUE ( 'Table'[Column] ) = "SUM NET_SALES",
    [SUM NET_SALES],
    IF (
        SELECTEDVALUE ( 'Table'[Column] ) = "NET_SALES GTH (%)",
        [NET_SALES GTH (%)],
        IF (
            SELECTEDVALUE ( 'Table'[Column] ) = "SUM EBITDA",
            [SUM EBITDA],
            IF (
                SELECTEDVALUE ( 'Table'[Column] ) = "EBITDA_GTH (%)",
                [EBITDA_GTH (%)],
                BLANK ()
            )
        )
    )
)

Best Regards,
Icey

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

[Anonymous]

@Icey  If i use multiple selection data is not showing. how can i select 1or more filter at a time.

[Icey]

Hi @Anonymous ,

Add 'Table'[column] to Legend.

Best Regards,
Icey

[bkr]

Is there a chance to get the pbix file containing the solution?

I'm trying to reproduce this but it doesn't work for me.

[Anonymous]

@Icey  Thanks a lot.

[Anonymous]

columns showing based on slicer selected values in currently not possible in power BI. You can pivot your dataset and acheive your result.