Best visual to represent the current rank and target rank?

[nandukrishnavs]

Dear community friends,

I'm trying to represent the below data in a meaningful way. Other than the table/matrix, which visual will be the most effective one?

Country	Current Rank	FY 21 Rank	FY 25 Rank
Country1	15	12	5
Country2	23	20	12
Country3	8	5	1
Country4	20	20	10
Country5	10	8	2

Any help would be appreciated. 

Thanks in advance.

Nandu Krishna

[Greg_Deckler · Accepted solution]

I would refer to this: https://www.sqlbi.com/ref/power-bi-visuals-reference/

[Greg_Deckler · Accepted solution]

I would refer to this: https://www.sqlbi.com/ref/power-bi-visuals-reference/

[nandukrishnavs]

Thanks @Greg_Deckler . This is very useful. But I couldn't find any direct answer to my question.

[Greg_Deckler]

@nandukrishnavs  - Looks like for Rank if you want to stick with OOTB visuals, go with Clustered Column or Bar chart. You could have countries as legend and Ranking categories as axis or vice versa. Could add in averages, targets, etc. via Analytics pane. I don't know, not sure what you are going for or exactly what your data looks like ultimately. I assume you have a Country column and then is there a row for each year and a rank?

[nandukrishnavs]

@Greg_Deckler - Only current value will be updated every quarter. We have to show the current rank and two targets.

[Greg_Deckler]

Ah, now I understand, let me try a few things.

[Greg_Deckler]

What about a clustered column and line chart?

[nandukrishnavs]

@Greg_Deckler I tried to represent only markers instead of connected line. Another option, representing the targets as another bar. We are brainstorming to finalize the right one.

[v-gizhi-msft · Accepted solution]

Hi,

Maybe you need something like this?

See my attached pbix file.

Best Regards,

Giotto

[nandukrishnavs]

Thanks @Greg_Deckler & @v-gizhi-msft