Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Try your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now

Reply
Cintozonna
Regular Visitor

Use filter value as variable

Hello !

 

Here is my problem:

 

I have a file with 10 companies, with different kind of parameter : Name, Number of Engineer, Number of commercial, Number of HR,…

I would like to create a page that can compare 2 of them. Thus, I used 2 independent smart filter (editing relationships) for the same parameter: Name of the company.

Then, what I would like to be able is : Depending of the two company chosen, showing some interesting data that compare the two companies. For example : the difference of number of engineers, commercial, HR  …

I insist on the fact that I want to perform operations and not only show the values of each (what I already have)

 

Do you have ideas ?

 

Many thanks

Cinto

1 REPLY 1
v-yuta-msft
Community Support
Community Support

Hi Cintozonna,

 

Can you give some tables with dummy data and clarify more details about how to compare the difference?

 

Regards,

Jimmy Tao

Helpful resources

Announcements
Fabric Data Days is here Carousel

Data Days 2026

Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.