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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
RhinoceRoss
Frequent Visitor

Bar Chart dynamic title - unable to place a text measure as the title anymore.

Hello Community,

I am having an issue in where I want to place dynamic titles into the title and subtitle of a barchart, with the end goal of showing Totals and Months of Month and Year on Year KPI's.

 

However before I even get to the harder calculations and formatting I cannot even add a text measure as a title or subtitle. 

I have also tried this with a formatted measure of a kpi i will eventually use and still same issue. I cannot select the text measure into the "What field should this be based on" box 

 

The only thing I have been able to do is throw in a column from a data table in, for example I created a blank column and I can select that but that is not what i am after.

 

is this an issue that is being looked at? 

I have found a work around for this months reporting but future reporting will need the dynamic title as my work around isnt perfect. 

 

kind regards,

Ross

 

RhinoceRoss_0-1708946757388.png

RhinoceRoss_1-1708946801673.png

 

1 ACCEPTED SOLUTION
barwe
Frequent Visitor

Hey, is your measure's Format set to Text? 

barwe_0-1708957088588.png

 

View solution in original post

2 REPLIES 2
RhinoceRoss
Frequent Visitor

My Absolute hero!! thankyou! i knew it would of been something so basic i was missing but i was just unaware that even if i format the measure with DAX it didnt change the format of the measure. 

Thankyou, i'll never make that mistake again works perfectly now

barwe
Frequent Visitor

Hey, is your measure's Format set to Text? 

barwe_0-1708957088588.png

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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