Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago
Solved

Dynamic Title on Bar Chart

Good afternoon, I hope you are well. I have the following difficulty. I want to create a dynamic title in a 100% stacked bar chart, I have just one table like the image below With this data,...
  • Syndicate_Admin's avatar
    Syndicate_Admin
    2 years ago

    Hello, Thanks for the help.

    In the end the solution was very simple, the table and the graph were not interacting with each other, the default graph had active the (highlight) and not (filter) so when I selected any product from the table the graph moved but did not change the name, I changed the interaction from scrape to filter and what I was looking for worked perfectly.

    I tried the original measurement I included in the question and it turned out, I also tried the measurement you indicated above and it works too.

    Thank you all for the help, problem solved.

    Best regards

Daniel29195's avatar
Daniel29195
Icon for Community Champion rankCommunity Champion
2 years ago

Syndicate_Admin 



check 1 : make sure that the table visual is reading product column from the dimension table .

 

check 2: try this measure

Title Bar 2 =
var _Filtro =
calculate( max(dimProducts[Products] , table_name ) 
return
if ( isfiltered(dimProducts[Products]) , _Filtro , "All Products" 
)
 
 
hope this works for you . 
 
 
 
 
If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit that  thumbs up button 🫡👍
 
 
 
  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    2 years ago

    Hello, Thanks for the help.

    In the end the solution was very simple, the table and the graph were not interacting with each other, the default graph had active the (highlight) and not (filter) so when I selected any product from the table the graph moved but did not change the name, I changed the interaction from scrape to filter and what I was looking for worked perfectly.

    I tried the original measurement I included in the question and it turned out, I also tried the measurement you indicated above and it works too.

    Thank you all for the help, problem solved.

    Best regards