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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
BenCardineau
Helper I
Helper I

dynamic title using calculation group

Hi Folks.

 

using the awesome Tabular Editor, I created a calculation group to format values in $ or Hours depending the selectedvalue of a drop down. That works fine with my values. The problem is the title of my visual is also dynamic ("Project Hours" or "Project $"), but as soon as I introduce the value formating in the visual, my title turns into an ugly "$#,##0" or "#,##0h" instead of the string expression. I tried to avoid the formating of the text measure following the Great Marco Russo's article here, with selectedvalueformatstring() expression, but then the title just doesn't show up at all... 😞

 

Any idea on how to bypass the formatting for dynamic text measures?

Thx a lot,

Ben

1 ACCEPTED SOLUTION
Daryl-Lynch-Bzy
Resident Rockstar
Resident Rockstar

Hi, @BenCardineau -
Are you trying to use a Measure to define the Title Text?  If so, when you define the text string measure, you need to exclude it from your Calculation Group rules.  I think you need to add a ISSELECTEDMEASURE() condition to your calculation groups so it focus on the Metric Measures only, and ignores String Measures.

For example:
Metric Measure = SUM ( [Amount] )
Text Measure = IF ( SELECTEDVALUE ( [Project Type] , "Hours" ) = "Dollar" , "Project $", "Project Hours")

In the calculation group expression, the following is required.
IF ( NOT( ISSELECTEDMEASURE( [Mertric Measure] ) ), SELECTEDMEASURE() , IF ( SELECTEDVALUE ( [Project Type] , "Hours" ) , Use Dollars , Use Hours ) )


In the Expression Format, the following is added.

IF ( NOT( ISSELECTEDMEASURE( [Mertric Measure] ) ), "" , IF ( SELECTEDVALUE ( [Project Type] , "Hours" ) , Use Dollars format , Use Hours format ) )

 

I hope this helps you find the right solution.

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hi Ben, 

I am facing a similar problem, did the solution work for you? Or how did you fix this? 🙂 

Hope you can help, as i am really stuck here 😞

 

BenCardineau
Helper I
Helper I

Hi @Daryl-Lynch-Bzy thx for your inputs! Yes, that's in essence what I had done... I replicated it in a brand new file (with exact same code as in the initial file), where it worked ok. After scratching my head around this for some time, I believe it's due to the fact that my initial file has RLS, and some roles in RLS do filter the 'Selection' field ("hours" or "$")... Do that make sense to you, that RLS may affect like this, even in desktop?

Anyway, thx again for your help!!

Ben

 

Daryl-Lynch-Bzy
Resident Rockstar
Resident Rockstar

Hi, @BenCardineau -
Are you trying to use a Measure to define the Title Text?  If so, when you define the text string measure, you need to exclude it from your Calculation Group rules.  I think you need to add a ISSELECTEDMEASURE() condition to your calculation groups so it focus on the Metric Measures only, and ignores String Measures.

For example:
Metric Measure = SUM ( [Amount] )
Text Measure = IF ( SELECTEDVALUE ( [Project Type] , "Hours" ) = "Dollar" , "Project $", "Project Hours")

In the calculation group expression, the following is required.
IF ( NOT( ISSELECTEDMEASURE( [Mertric Measure] ) ), SELECTEDMEASURE() , IF ( SELECTEDVALUE ( [Project Type] , "Hours" ) , Use Dollars , Use Hours ) )


In the Expression Format, the following is added.

IF ( NOT( ISSELECTEDMEASURE( [Mertric Measure] ) ), "" , IF ( SELECTEDVALUE ( [Project Type] , "Hours" ) , Use Dollars format , Use Hours format ) )

 

I hope this helps you find the right solution.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.