Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Table Dynamic title

Hello everyone,
I'm new on power bi and I have 7 charts and one table, I'm trying to Have Dynamic titles For All my charts based on the filter that I will do, But I don't want when I'm filtering on the table the other chart title to change.

 

I'm Using a 7 measures Like this and I'm use it on the title of the chart

This the Measures :
Title =
VAR t1= SELECTEDVALUE(ColumnName],"Text1")
VAR t2=SELECTEDVALUE(ColumnName],"Text2")
VAR t3=SELECTEDVALUE(ColumnName],"Text3")
VAR t4=SELECTEDVALUE(ColumnName],"Text4")
VAR t5=SELECTEDVALUE(ColumnName],"Text5")
VAR t5=SELECTEDVALUE(ColumnName],"Text6")
RETURN
    if (NOT(t1=="text1"), (CONCATENATE(" text",( " text" & t1))),
    if (NOT(t2=="text2"), (CONCATENATE(" text",( " text" & t2))),
    if (NOT(t3=="text3"), (CONCATENATE(" text",( " text" & t3))),
    if (NOT(t4=="text4"), (CONCATENATE(" text",( " text" & t4))),
    if (NOT(t5=="text4"), (CONCATENATE(" text",( " text" & t5))),
     t1)))))
 

Thanks in advance.

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , if you want the chart to filter but not the chart title, that is doubtful. If you do stop interaction between table and chart and table will not filter( Format -> edit interactions )