Visualization help

[Anonymous]

Hey everyone,

I need some help in how to solve some issue.

I have two tables which are connected. I created measures on the basis of information from these tables. The measures are price/kg and complaints/kg. I now want to visualise the top 3 of price/kg and complaints/kg in the same graph (with country being on the X axis). If I select the top N filter, it only filters on the basis of either price/kg or complaints/kg. How can I solve this?

Thanks in advance.

[Anonymous · Accepted solution]

Hi,@Anonymous 

Regarding the issue you raised, my solution is as follows:

1.First I have created the following table and the column names and data are the data you have given:

2. Below are the measure I've created for your needs:

RANKCOM = RANKX(ALL(complaints),[complaints/kg],,DESC,Dense)

RANKPRI = RANKX(ALL('PRICE'),[price/kg],,DESC,Dense)

3.Then I modified the filtering of the visualization objects as shown below:

4.Here's my final result, which I hope meets your requirements.

This allows you to preserve both filters and only display values that are in the top three of both measures.

Please find the attached pbix relevant to the case.

Best Regards,

Leroy Lu

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

[Anonymous]

Thanks for the help