Forum Discussion
Helper VShow/Hide Data on Visual Based on Another Visual
Hello,
I have a dataset with over 15 million rows and 70 columns. I am trying to create a report that shows a summarized view on the top and detailed breakdown in a table view at the bottom. Because of the size of the dataset, the table visual keeps throwing an out of memory error. To be able to display the two visuals together, we have two options -
1. Set the table visual to only load/preview top 100 records, and then as the user clicks on the summary view on the top, filter the table and show records pertaining to that
2. Have the table visual be blank, unless a user selects a record on the matrix visual on the top.
So as an example, if my data is summarized as follows, I'd want Power BI to show the bottom table to be blank by default, and then if a usre clicks on a record on the matrix visual (e.g. dairy), the bottom table gives details. This will allow us to load the visuals without running out of resources.
Would this be possible in Power BI? I'd really appreciate any help!
2 Replies
- Fowmy
Super User
newpbiuser01
I will demonstrate based on my sample data model. First creata a measure.ShowRecords = INT(ISFILTERED( 'Date'[Year]))
Assign it on the Visual Filter of the table where you need to show/hide data.
Notice, the nothing is selected on the year table so no records are visibleSelecting a value on the year table, shows the data.
- Idrissshatila
Hello newpbiuser01 ,
I've never seen a project that uses 70 columns, I would recommend you remove the rows that you don't need in your requirements and try to do some grouping in power query and make a star schema data model. And visuals won't throw memory errors anymore.
