Variable value for graphs

[lienbrusselaers]

Hi all,

I'm trying to build a dashboard to get more insights into our users. Filtering is really important create segments and to find insights easily. I want to have one page with insight on my user segmentation (where do they come from, what are their interests when did they sign up, etc.). Preferably these are just two graphs next to each other that I can filter and segment on the go.

This is what my data looks like:

	Company	Industry	Country	Sponsor
User2	XX	AA	Belgium	1
User3	YY	AA	Belgium	1
User4	XX	AA	Belgium	1
User5	YY	BB	France	3
User6	YY	CC	Belgium	4
User7	ZZ	CC	Belgium	2

Is it possible to create a graph that can show company, industry, county, sponsor, depending on what you select? So to make this graph 'variable'. If I want information on the number of users/company, there is a dropdown with company/industry/county/sponsor from which I can select company and it shows me the number of users/company.

Does anyone know if this is possible?

Thank you so much in advance!

Kind regards,

Lien

[rajulshah · Accepted solution]

Hello @lienbrusselaers ,

I think this link can help you:
https://www.inkeysolutions.com/blogs/power-bi-dynamic-scales-values/

[rajulshah]

If the solution helped you, then please mark the post as Solution so that it is easy for others in need.

So the answer to your other question is that you can create a measure that derives difference between them and then the measure can be used in different table.

[lienbrusselaers]

Ok great thank you. I'll try this out!

Do you know if it's possible to make a comparison between two segments (just two graphs or tables side by side with different slicers/filters) and make a comparison table from these? So the output should be something like this: