slicers that defines exclusives contracts for each seller

[mscla]

Hi everyone, 

I need a help with something that seems to be easily, but, I didn't' found any solutions

I have a list of contracts in the Main Table, then, I have 3 columns for each seller, that is, if the value is 1 then it means that this contract can be assign to the sellers: ING, COM, DES.

my objective is to create 3 tables (matrix visual), one for each seller, and create slicers in which I can remove a certain seller from a certain contract.

For example, in the Table ING if I unassign all contracts from DES and COM, it means that I am assigning all exclusive contracts to ING, so I want the other tables to delete the contracts that have already been assigned to ING in table 1

how can I do that?

Do I have to work with Power automate?

sales_asssign.pbix 

[mscla]

thanks Yilong,

I'm trying another solution..
In fact, I have to create 3 tables with unique contracts for each COM, ING and DES.

I tried to do this using Power Automate to create a SharePoint list, but the flow run to bring the data back to the dataset is too slow..

Do you have any ideas how I can do this?

[v-yilong-msft]

Hi @mscla ,

Sorry for the long it took to reply to you, do you have a solution or any new ideas now?

Best Regards

Yilong Zhou

[mscla · Accepted solution]

Hi @v-yilong-msft 

Yes, this post helped me
https://community.fabric.microsoft.com/t5/Desktop/Error-in-the-minimum-value-range-slicer-for-a-spec...

thanks

[v-yilong-msft]

Hi @mscla ,

I think you can create a measure and a calculated column.

Measure = 
IF ( MAX ( 'MAIN TABLE'[ING] ) = 1, BLANK (), MAX ( 'MAIN TABLE'[contract] ) )

Column = 
IF('MAIN TABLE'[COM]=1,BLANK(),'MAIN TABLE'[contract])

So you can try these codes and it will get you what you want.

Best Regards

Yilong Zhou

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