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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Nazdac911
Helper II
Helper II

How to create a dynamic title/smart narrative that can detect all factors that effecting a visual

Hi all 

I have a tab that comntains only one visuual "Stacked Column Chart" and 6 slicers that effecting it. 

of course for most of the users follwing the contecxt will be challenging so I was wondering , is it possibe to build a dynamic lable for the visual. 

It wil be great if the title can show either the choosen values in slicers or at least the used slicers the influence . 

Also can I add a smart narrative that can show this in a formatted user freindly way 

something simmillar to what filter ocon show on the top of each visual 

Nazdac911_1-1675680969285.png

 

Thanks in advance 

REgards 

 

1 ACCEPTED SOLUTION
v-yueyunzh-msft
Community Support
Community Support

Hi , @Nazdac911 

Understanding the filter context applied to a measure in a Power BI report can be a challenging task. Filters can be applied at the report, page, and visual levels. Every visual element in a report can filter other visuals in the same page. Determining the exact filter in complex reports can be an expensive but necessary task during report validation or debugging. For example, the following screenshot shows the DumpFilters measure applied to a Tooltip in a clustered column chart.

For this , you can refer to :
Displaying filter context in Power BI Tooltips - SQLBI

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

View solution in original post

1 REPLY 1
v-yueyunzh-msft
Community Support
Community Support

Hi , @Nazdac911 

Understanding the filter context applied to a measure in a Power BI report can be a challenging task. Filters can be applied at the report, page, and visual levels. Every visual element in a report can filter other visuals in the same page. Determining the exact filter in complex reports can be an expensive but necessary task during report validation or debugging. For example, the following screenshot shows the DumpFilters measure applied to a Tooltip in a clustered column chart.

For this , you can refer to :
Displaying filter context in Power BI Tooltips - SQLBI

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Users online (1,431)