Dynamic Tittle is Not writting for Blank Values of Measures

[PrakashSrinivas]

I am using a Bar chart. Which has just one dimension for X axis and two measures for Y axis(Failed & Long Run)

Dynamic tittle works good for selectedvalue of Dimension Column. However when for date selection and there is no data for Failed and Long Run Measure, the visual becomes blank. I am trying to display something but the below DAX is not working. 

Dynamic Tittle = if(
isblank([Total Failed]) && isblank([total Long Run]) , "NO Data Found", selectedvalue(Dimensiontable))

[PrakashSrinivas]

Thank you for responding. I used the above method. It is displaying the tittle with the selected value.(no dates are selected)

As soon as i slide the calender to some other range and when there is no data, tittle and entire visual getting blank.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[PrakashSrinivas]

Here is my extended explaination about the scenerio.

Columname = Track_Name ( x axis of Bar Chart)

Measure 1 = [Total_Failed] ( Y axis of Bar Chart)
Measure 2 = [Total_LongRun] ( Ya axis of Bar Chart) 

I am using dates between for Date slicer. 
Once i select any Track value in the Track_Column Slicer i will see a Track Name as Tittle. "XSR" . And it is the result of all dates. But as soon as i slide the dates to different range, when there is no data for [Total_Failed] and [Total_LongRun] , Tittle will go off. But still slicer selection shows XSR itself. I tried the below DAX, and it is not working.

Dynamic Tittle = if( isblank([Total_Failed]) && isblank([Total_LongRun]) , "No Records for " & Selectedvalue(Tablename[Track_Name]) , Selectedvalue(Tablename[Track_Name])) . 

Just expecting if we can dispay "No Records for XSR" . is there any possible way we can achieve this.

Thank you.

[v-menakakota]

Hi @PrakashSrinivas ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[PrakashSrinivas]

Hello @v-menakakota . Sorry i missed to respond . Actually i have tried this measure, but unfortunately it didnt work. It is just displaying "No Records Found For"
and not displaying the Track.

Thank you for the Help

[v-menakakota]

Hi @PrakashSrinivas ,

Thank you for reaching out to the Microsoft Fabric Community Forum.

We really apologies for the inconvenience, after reviewing the issue ,You're absolutely right  when no data is returned by the measures, Power BI may treat the entire visual context as empty. As a result, even though a value is selected in the slicer, SELECTEDVALUE() might return blank because it's being evaluated within a context where no rows exist.

To handle this, we can use ALLSELECTED() to retrieve the slicer selection independently of the visual’s data context. This ensures that the selected value is preserved even when the measures return no data. Here's the updated DAX to try:

Dynamic Title =
VAR SelectedTrack = SELECTEDVALUE(ALLSELECTED(Tablename[Track_Name]))
VAR HasData = NOT (ISBLANK([Total_Failed]) && ISBLANK([Total_LongRun]))

RETURN
IF(
NOT ISBLANK(SelectedTrack),
IF(HasData, SelectedTrack, "No Records for " & SelectedTrack),
"No Records Found"
)

If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.

[PrakashSrinivas]

@v-menakakota Thank you for the response. Unfortunately this is not working. Once we enter "Selectedvalue" , it is unable to select "Allselected" inside .  

[v-menakakota · Accepted solution]

Hi @PrakashSrinivas ,

Thank you for reaching out to the Microsoft Fabric Community Forum.

We really apologies for the inconvenience, can you please provide usable sample data.

Thank you and Regards,
Menaka Kota

[v-menakakota]

Hi @PrakashSrinivas ,

Could you please confirm if the issue has been resolved on your end? If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.
Thank you for your understanding and assistance.

[v-menakakota]

Hi @PrakashSrinivas ,

Can you please confirm whether you have resolved issue. If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. This will be helpful for other community members who have similar problems to solve it faster. 

If we don’t hear back, we’ll go ahead and close this thread.Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

Thank you. 

[v-menakakota]

Hi @PrakashSrinivas ,

Thank you for reaching out to us on the Microsoft Fabric Community Forum.
Actually this may occurs because when [Total_Failed] and [Total_Long Run] return BLANK, Power BI may also treat SELECTEDVALUE(Track_Name) as BLANK, causing the title to disappear.

Dynamic Title =
VAR SelectedTrack = SELECTEDVALUE(Tablename[Track_Name])
VAR HasData = NOT (ISBLANK([Total_Failed]) && ISBLANK([Total_LongRun]))

RETURN
IF(
NOT ISBLANK(SelectedTrack),
IF(HasData, SelectedTrack, "No Records for " & SelectedTrack),
"No Records Found"
)

Once try this measure it may help you

If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.

[lbendlin]

I cannot assist you if you are unable to provide usable sample data. I hope someone else can help you further.

[lbendlin]

Use COALESCE()

Dynamic Title = COALESCE(selectedvalue(Dimensiontable[Column]),"No Data Available")