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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
x0
Helper I
Helper I

Slicer Visual multiselection error

Hello Evevryone ,

 

Please help me with solve the query of multiselection on slicer i have been try using enable multiselect on visual settings appear some error with no data. here is screenshots 

screenshot number 1 :  with data on single selection 

x0_3-1706788366853.png

 

 

 screenshot number 2 : multiselection but no data 

x0_2-1706783872309.png

x0_4-1706788430743.png

can i have any solution ? 

Note : I am using Messures from all table on single matrix value. 

5 REPLIES 5
miTutorials
Super User
Super User

It looks like in your measure you are using "Selectedvalue" Function to calculate. It will be good for you to post the measure here so that we can help you.

 

Regards

Ismail

FadilatBraimah
New Member

Further clarification will help but this looks like there is an issue with your measures.
Ensure you are using your aggregate functions correctly. be mindful of row and filter contexts in DAX. check for blanks and your data modeling.

Anonymous
Not applicable

Correct me if im wrong ....you want to multiselect a slicer but when u do it the data is not being displayed and error is shown!? 
can you please share your data set for better understanding?

Hello @miTutorials 

 

I solved the issue it was falut on messure i modified messure with in function now its is display 3 month data too i mean multi select is working 

could you assit me on another query ? 

let me share my sceanario on this dashboard as you can see 2 slicer 1 matrix and 123 card 

now i am using this custom table for filter data so on 2 slic i add property column and Custom date column

here is custom table which is take 3 information from all table 

CustomTable =
DISTINCT(
    UNION(
        SELECTCOLUMNS('Conversion', "LeasingAgent", LOWER('Conversion'[Leasing Agent]), "Property", 'Conversion'[Property], "CustomDate", 'Conversion'[CustomDate]),
        SELECTCOLUMNS('Move Insq', "LeasingAgent", LOWER('Move Insq'[Leasing Agent]), "Property", 'Move Insq'[Property], "CustomDate", 'Move Insq'[CustomDate]),
        SELECTCOLUMNS('J Turner Dashboard', "LeasingAgent", LOWER('J Turner Dashboard'[Leasing Agent]), "Property", 'J Turner Dashboard'[Property], "CustomDate", 'J Turner Dashboard'[CustomDate]),
        SELECTCOLUMNS('Online Review', "LeasingAgent", BLANK(), "Property", 'Online Review'[Property], "CustomDate", 'Online Review'[CustomDate]),
        SELECTCOLUMNS('Shop Report Tracker (2)', "LeasingAgent", LOWER('Shop Report Tracker (2)'[Leasing Agent]), "Property", 'Shop Report Tracker (2)'[Property], "CustomDate", 'Shop Report Tracker (2)'[CustomDate])
    )
)

 

now on matrix  column area i use leasing agent from custom table to see as header 

and on 2 slic i add property and custom date from custom table 

problem is on card 123 i use measure to see total or value 

so on card i use this measure 

Lead conversion First visit to 1 =
ROUND(CALCULATE(
    DIVIDE(
        SUM('Conversion'[Applications Completed]),
        SUM('Conversion'[First visit/tour])
    ) * 100,
    ALLEXCEPT('CustomTable', 'CustomTable'[Property], 'CustomTable'[CustomDate])
),1

)
but it doesnt work mean showing me wrong value 
but if i remove property and custom date from custom table and use own table column it is showing perfect value 
x0_0-1707213977171.png

highlighted part is my value on card here i am facing issue . 

 

hello @miTutorials 

 

For your reference 

this is original value but its comes with filter from conversion table i mean own table not from custom table.  and i would like to see this value on my main dashboard using custom table column filtering. 

 

x0_0-1707215446295.png

 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors