Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
kageyoshi888
New Member

Dynamic number of rows based on what if parameter

‎02-10-2023 02:21 PM

Hi, I've found somewhere that report

 

https://app.powerbi.com/view?r=eyJrIjoiYjUzMTYyNTUtYzBkZC00ZGQyLTkzMGMtNmU5MDBiZDU2ZWUwIiwidCI6IjdkM... 

 

in second page, the first table visual changes the number of rows based on this what-if parameter number

Zrzut ekranu 2023-02-10 o 23.20.35.png

 

How can I achieve something similar? 

Labels:
Message 1 of 2
303 Views
0
1 REPLY 1
amitchandak
Super User
Super User

‎02-10-2023 08:37 PM

@kageyoshi888 , Create a TOPN measure with help of this and use it in visual or as the visual level filter

 

TOPN: https://youtu.be/QIVEFp-QiOk
TOPN with Numeric Parameter -https://youtu.be/cN8AO3_vmlY?t=26448



Message 2 of 2
252 Views
0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

View All