Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Dynamic title in chart

I follow the blog http://sqljason.com/2018/03/display-last-n-months-selected-month-using-single-date-dimension-in-powe... in order to display Display Last N Months & Selected Month using Single Date Dimension in Power BI.

 

Now my issue is how to display title of the chart dynamically?

 

I tried to add new callculated colum dynamictitle="total sales per month(over the last" & N[N] & " months)"

 

But it returns always total sames per month (over the last months

The N parameter returns blank hwo to correct it please? 

Need Help

4 Replies

    • YukiK's avatar
      YukiK
      Impactful Individual
      4 years ago

      AnonymousAnother vote on this!

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      amitchandak I try it and it does not work. It returns thr maximum value of the parameter that I choose when I create the parameter

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi Anonymous,

        Current power bi does not support creating dynamic calculated column/table based on filter/slicer.
        They were works on different data levels and you can't use the child level to affect its parent. For this scenario, I'd like to suggest you create a measure expression instead.

        Notice: the data level of power bi.

        Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)

        Regards,

        Xiaoxin Sheng