Report, filter by name of header column

[XaviOV]

Hi,

I would like to know how to be able to filter the different data with the name of the column in the Report section. For example, if you want to see the data of a water meter, clicking on the name of the meter will show those values.

The date row refers to the others to filter by date.
I attach a screenshot with a part of the data.

Regards,

Xavi

[v-deddai1-msft]

Hi @XaviOV ,

Would you please use the query editor to transfer data first:

Select all the columns you want to be able to filter (using shift and or control) ,right-click and select unpivot data

And you will get a new Attribute column, then you can create slicer to filter data by what  you want

Best Regards,

Dedmon Dai

[XaviOV]

Hi @v-deddai1-msft

I tried it, but I have calculations with different columns and when I do "Unpivot columns" this error appears (attached image).

If I created a new sheet in the excel file with the names of the calculated columns and related it to the table of calculations? Would it work?

Regards,

Xavi

[v-deddai1-msft · Accepted solution]

Hi @XaviOV ,

In PowerBI desktop, we can only unpivot table in Query Edit. It is not allowed to use DAX to change the table structure. And as you know, calculated columns will not display in Query edit, so I suggest you transfer data in query editor ,use custom column instead of calculated column.

Best Regards,

Dedmon Dai

[XaviOV]

Hi @v-deddai1-msft ,

Is there another solution to not do more calculations?

Regards,

Xavi