Forum Discussion

leocalegario's avatar
leocalegario
Regular Visitor
9 years ago

Filter Colluns

Is possible to apply filter by the columns instead the lines? Because my ''Date'' information (Months) are like columns (At the end it was need to be like this, whatever...).   By now, Thanks. Leo...
Dashboards
v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

leocalegario

 

It is not supported to apply filter by the columns instead the lines. I think you data is like below. The month names are the column names. You can select all the columns and click unpivot columns in Query Editor to transform the table. So that we can apply filter by the lines.

 

 

Best Regards,
Herbert

MarcelBeug's avatar
MarcelBeug
Icon for Community Champion rankCommunity Champion
9 years ago

Alternatively you can:

  • transpose the table or
  • select columns or
  • create a custom function to filter on values in (a) specific row(s), but that requires more detailed information on the requirements.