tabular report

[lilimab]

I am new to power bi desktop

i have this report  and two slicer to select value, slicer has values value as settings from same table but two different views like proudct category and subcategory, how can i show the slicer selection value on the below report. please help me to show the selected value from slicer in the blow format. As far as i know we can only mentioned onlye on selected slicer value in the report not two slicer selected value. Please help

[amitchandak]

@lilimab , Not very clear, if take proudct category and subcategory in visual and they are filtered bu a slicer. You will get only selected values in visual ?

[lilimab]

Sorry for that Matey, i will try to explain as clear as i can.

i have one table with 20 columns, 10 columns in a one slicer and rest of them are in other slicer.

user can select any value from these two slicers. i need to filter the main table based on selected column and then show it in the matrix report with both slicer selected value as row shown in my screen shot.

Let me explain what i have tried, i have create two sql views for two slicers, and merge these two views as one view and use that view column in matrix rows. Define the relationship in these 3 views in model, but it does not work as expected if i select one slicer value it work but both does not work .Hope i have explained it in a better way now. please do help me i am stuck here.

Thanks in advance,

Lilima.