Column Name

[jx615k]

Hi Comunity Team,

Can a measure tretreive a column name? What I am trying to do is filtering data based on a column name.

Thanks and regards.

[PBIfanatic]

Hi @jx615k 

Please can you explain a bit more on what you are trying to achieve?

[jx615k]

Thanks for your responce!

I want to have 2 slicers (slicer 1 and slicer 2). In slicer 1 I can pick up one of different Items, lets say "Item A" then Slicer 2 will have values From Column A. If I select Item B from Slicer 1, then Slicer 2 will have values from colum B and so on and on. Basically I have many Date columns and the users will pick up 3 of those columns to filter data so any user can select Coumn A, B and C, while others can select C, F, Z..... etc. I Cannot have 1 slicer per column since I would require more than 40 slicers so it wont be a great option so my goal is having 6 slicers, 3 containing Items from A to Z and the other 3 will contain any column from Column 1 to column N.

Thanks again for your kind support.

[camargos88]

Hi @jx615k ,

You can create a measure and compare the values selected by the slicer and get the column. Example:

Ricardo

[jx615k]

Hi Ricardo!!!

That is almost what I am looking for, is there a way I can replace the Dynamic table for a Slicer with date values?

For instance, if Country is CAN, then show a slicer from column  "Canadian Holidays", if Country is JPN, then show a slicer from column "Japan Holidays" and if Country is USA then show a slicer from column "USA Holidays"

Thansk in advance for your suport Ricardo 😃

[PBIfanatic]

Hi @jx615k ,

Try creating a calculated column for the second slicer - for the column canadian holidays. Your first slicer would be country.

CALCULATE(VALUES('COLUMN-CANADIAN HOLIDAYS', ALLSELECTED(COUNTRY))

Based on the selection from your first slicer, this calculated column will populate the holiday values for Canada.

[amitchandak]

@jx615k , Refer if this can help

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

[camargos88]

@jx615k ,

Maybe bookmarks can help you with that, have you used it ?

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

Ricardo