Switch units and columns with a filter

[JohanSmith7]

Hi all, I need an idea to achive the following:

I need a filter that allows users to switch betweeb the options in the screenshot below.

COGS, Aswas COGS and Local COGS are three different columns in my data set. I've seen that some post shows how to take i.e COGS and with simple division gets the number in thousands (K) and in millions (M) units, but in this case I have different columns and not sure what would be a good approach.

This screenshot is from a QlikSense Dashboard that needs to be replicated in Power BI.

pd: all the graphs in the dashboard needs to be filtered by this filter.

Any idea would be highly appreaciated,

Thanks in advance,

[v-yueyunzh-msft]

Hi , @JohanSmith7 

I'm not quite sure what you want in the end.But if you want to get the "K","M"，you can create a calculated column to extract the value. And we can use MAX() function to get the value.

For you say you need to "all the graphs in the dashboard needs to be filtered by this filter", the best way is that to create relationships between two tables, you can use "1..10" to falg your data.

If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.

Best Regards,

Aniya Zhang

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