Filter Columns in Data View

[Twan]

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 useful for exploring the data and inspecting how calculated columns are evaluating.

Thanks,

-Anthony

[mcanas07]

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]

@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]

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 😞

[Greg_Deckler · Accepted solution]

@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.

[Twan]

Thanks @Greg_Deckler,  I'll go look in the ideas section and see if anyone else has posted this idea and post it if nobody has.

I also figured out that you can go to the Home ribbon -> Edit Queries and it brings up a view similar to the data view where you can filter columns.  The only issue is that this view of the data does not contain calculated columns.