Forum Discussion

Twan's avatar
Twan
Advocate IV
10 years ago
Solved

Filter Columns in Data View

Is there any way to filter columns when viewing a table in the data view in Power BI desktop?     In PowerPivot it is possible to filter each column when viewing the data in Data View.  This is use...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    10 years ago

    Twan - I am not aware of a way to do this, you can right click a column and sort. Probably a good thing to post to Ideas if not there already.

mcanas07's avatar
mcanas07
New Member
10 years ago

 

Hi there, 

I am new to the forum and just started using PowerBI today and although I am liking it so far, I feel a bit let down with the unavailability to filter my columns in data view as I would like to check if my calculated columns are working as they should.

 

Has a solution been found to this yet??

 

Thanks,

mcanas

Anonymous's avatar
Anonymous
Not applicable
10 years ago

mcanas07 Looks like that feature was requested (and you may have commented based on the anonymous comment date) here Doesn't look like it has much traction yet. This functionality isn't in the Desktop, but you can easily validate your calc column or measure by just creating a quick table in the Report section... In fact, you can build the Calc Column from the Report section as well, so there is no need to look in the Data section when building them.

  • mcanas07's avatar
    mcanas07
    New Member
    10 years ago

    Thanks Eno,

     

    That's exactly what i did (i.e. checked in report section) but was hoping that more people would want to do these type of checks before cracking on with reports. Fingers crossed this might get added in later releases if more people vote and yes anonymous was me there but don't know why it didnt have my username there :(