How to Hide a column in a table View but have it included for all row shwoing (Including Duplicate)

[Anonymous]

Hi All,

I Have a table where I added an Index column from Edit Query to count all the rows including the Duplicate. Now I dont want to show the Index column in the report view but want to include it so that the table display all the rows (Without the Index Column Power BI not showing the duplicates). I tried hiding the column but it doesn't work for my purpose. Is it possible to hide that Index column from the report/Visualization

Data Set

Report View

Any Idea how to fix the issue

Thank you all in advance 🙂

[ribisht17]

@Anonymous 

Hide Columns in Power BI | Power BI Tricks & Tutorials - YouTube

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users 

Regards,

Ritesh

[v-chuncz-msft]

@Anonymous ,

Just adjust the column width manually to hide it.

[Anonymous]

Hi @v-chuncz-msft ,

Thanks for your reply. I was just wondering if there was any other way to do it. Because if you manually adjust it then you can see the scroll bar at the bottom and I didnt want the users to drag the bar and get confused withthe Index #.

I wish BI had an option like Excel to hide the column from Visual.

Thanks for your reply 🙂

[Anonymous]

Did you ever find a solution? Collapsing definitely doesn't work.