Showing results for 
Search instead for 
Did you mean: 
New Member

Embedded report -- allowing users to control column visibility



Not sure I picked the right group for this -- please tell me nicely if I should post it in a different group.


We have a report showing certain financial metrics about a set of deals.  All deals have certain attributes -- Industry Sector (Energy, Agriculture, etc.), Region (East US, Central US, West US, Asia, etc.), year of first investment, and many more.


We have built the report showing the following columns:

  • Deal Name
  • Metric 1
  • Metric 2
  • Metric 3
  • Sector
  • Region
  • Year of First Investment
  • etc. (other attributes)


We have built slicers for the attributes for filtering purposes.  If someone wants to see just agriculture, it's right at their fingertips.  


Depending on who is looking, they may or may not care about Region, Sector,  Year or any other attribute.  So certain users have asked to be able to hide some of these columns when viewing the report.


Our Power BI developer insists it cannot be done, which I find very hard to believe.  Every report building tool I have ever seen and worked with lets columns get hidden, often by the consumers.


We don't need hiding the columns to do anything -- change grouping/filtering/rollup -- anything.  We just want the ability for the user to hide stuff they don't want to see so they have less noise.


Is this possible?  This is an embedded report hosted on Azure Power BI but that we have fronted through an iFrame on our intranet.  And this is a simplified example -- if I was really just 6 columns I would tell the users to deal with it, but in reality there are a couple of dozen deal attributes in play here.


Thanks in advance,



Helpful resources

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors