Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Ashish-Surti
Regular Visitor

Cascading issue in textbox parameter in power BI Report Builder in Power BI service.

Hello community,
I’ve created a report in Power BI Report Builder with 2 parameters (CaseID, ClassMember), then published it as a Paginated Report on Power BI Service and published the report in Power BI service or fabric.

  1. CaseID (Text) – Textbox
  2. ClassMember (Text) – Textbox
When entering a 'CaseID', the 'ClassMember' parameter value get populated in Textbox. However, I’m facing one issues:
Issue 1 : When entering CaseID 2104, Then ClassMember = Total Class Members-2104' parameter value get populated in Textbox.
But after entering a new CaseID 385, Then ClassMember = Total Class Members-385' parameter value is not populated in Textbox, and still show the old value 'Total Class Members-2104', New value is not able to load because it is still showing the old value and it is a cache issue.

How can I resolve these issues in power BI Report Builder OR Power BI Service? (I've attached a video for reference.)


1 REPLY 1
ToddChitt
Super User
Super User

First, why do you have TWO parameters when it appears that the second is simply using the first in a concatenation?

Suggest you eliminate the second paramter and any place you need that string, simply concatenate the literal string of "Total Class Members-" and the first parameter value.

 

Second, check the Advanced settings of the second parameter. Is it "Always refresh"?




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.