Field parameters or Another idea

[netanel]

Hey All,

I need help with a bit of a complex issue or not

I have a table of a particular report attaching data and image

I want to filter two columns in the same visual according to the different filters in a different DIM

Link to file: https://1drv.ms/f/s!AonyYI-TdspHgltwngZ6OKvpnSsc

[MFelix]

Hi @netanel ,

How are the filters you are refering connect to the data you have? On the example you present there is no column with the values you show on the filters.

Can you please give a little bit more insights on your model and expected result if you can please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.

[netanel]

Hey @MFelix 

All the filters are Dim Table

The Rows (Section in the pic) Came from DIM Account

The Numbers/Money Came from Fact Table

All the other filters are also Dimensions Tables 

I Also send you Privet message

Thanks

[Icey]

Hi @netanel ,

Could you create a sample model for us to test? Just use fake data.

Best Regards,

Icey

[netanel]

Hey @Icey 
I still can not send anything real but the example I attach is very close to reality
https://1drv.ms/f/s!AonyYI-TdspHgltwngZ6OKvpnSsc

I just want to know if I have a chance or a particular way to create the changes of the filters on the table
Working version vs final scenario vs a specific date
And constantly switch between modes

Appreciate the help very much!