Forum Discussion

Sun1's avatar
Sun1
Frequent Visitor
9 years ago
Solved

Tables of data

Hi All,   Slightly difficult to word this but here goes...   I have tables of data going as far back as 1999/2000. Each table differs in that some of the data items are not consistent through the...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi Sun1，

    Based on your description, you want to filter all the fields(column hearder in Trust Level  table). We are unable to achieve it, because the slicer is used to filter the row records in the table rather than columns. Thanks for understanding.

     

    Best Regards,
    Angelia

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Sun1,

You can create the report in Power BI desktop using any native visualization or custom visual. For the drop down filters,  i.e. Year, Level and Section in the web, you'd better create three slicers in the report. One year slicer, one Level slicer and another slicer including Section filter. More details about slicer, please review this article. Just like the report in the article, it will return different report when you select the different values in slicer, which is similar in the website report.

If this is what you want, please post the sample data and expected result for further analysis.


Best Regards,
Angelia