Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a report that shows projected parts issued based on forecasts. In the report, I have a slicer that allows the report consumer to select the Planning Center(s) that they want to see the forecasts for. They can select multiple Planning Centers. I have a second table that I use to show the Planning Center Descriptions that have been selected (the slicer is a long list that doesn't all apprear on the screen). If nothing has been selected in the slicer, the entire list of Planning Centers appears in the table of planning center descriptions. I would like this table to be blank until something is selected in the slicer.
Can someone tell me how to do that?
Solved! Go to Solution.
Sample data always helps...Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
That being said, try adding a hidden column measure like this:
Measure = IF(COUNTROWS(ALLSELECTED((Table))) = COUNTROWS(ALL(Table)),BLANK(),1)
Will return blank when nothing is selected, otherwise returns a value. Blanks will not show up in your table so the table will be blank until something is selected. Hide the measure column by turning off word wrapping and shrinking the column until it it doesn't show.
Sample data always helps...Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
That being said, try adding a hidden column measure like this:
Measure = IF(COUNTROWS(ALLSELECTED((Table))) = COUNTROWS(ALL(Table)),BLANK(),1)
Will return blank when nothing is selected, otherwise returns a value. Blanks will not show up in your table so the table will be blank until something is selected. Hide the measure column by turning off word wrapping and shrinking the column until it it doesn't show.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |