Dynamic Chart title for column chart for TOP N selected in Filter page (count--number)

[Apar_FM]

Dear Expert,

I am new in power bi

I have a column chart where I have selected the top 5 from the filter pane.

I want to have a dynamic chart title as below...

"Net Sales by State for Top" "XX" "State" (in place of XX I want --- count(number) of the selected item in filter pane)

My table name is "Sales" and my column name is "State"

Regards,

Tushar M.

[v-jianboli-msft · Accepted solution]

Hi @Apar_FM ,

Based on your description, I have created a simple sample:

Please try to apply the measure to the title:

Measure = 
var _a = COUNT('Table'[ID])
return "Net Sales by State for Top "&_a&" State"

Output:

Best Regards,

Jianbo Li

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

[MAwwad]

To create a dynamic chart title that displays the count of the top N states selected in the filter pane, you can use the following measure:

Chart Title = "Net Sales by State for Top " & RANKX(ALLSELECTED('Sales'[State]), 'Sales'[Net Sales],, ASC, DENSE) & " States"

This measure uses the RANKX function to determine the rank of each state based on its net sales, and then displays the rank as the chart title. The ALLSELECTED function is used to ensure that the ranking is based on all of the states currently selected in the filter pane.

[Apar_FM]

Hi DataSlyer,

It is not working. Maybe I am not able to understand my query better so I am rewriting it with a chart example..

Below is my chart where I already have the best 5 from the filter pane.

Now i dont understand is that how RankX will help me. I belive its may be count formula which is to be used.

Now from below if i choose 5 then it shows in title as 5 if top 7 then 7....