Forum Discussion
Hide Client Names when Client Selected
hummingbird what is the unique customers count? I'm trying to see what is feasible here.
Do you mean something like this?
I did this by creating a measure like so:
Selected Client = SWITCH( TRUE() , AND( HASONEVALUE( Clients[Client] ) , SELECTEDVALUE( Clients[Client] ) = SELECTEDVALUE( ClientData[Name] ) ) , SELECTEDVALUE( ClientData[Name] ) , AND( HASONEVALUE( Clients[Client] ) , SELECTEDVALUE( Clients[Client] ) <> SELECTEDVALUE( ClientData[Name] ) ) , "Other Client" , SELECTEDVALUE( ClientData[Name] ) )As it's using a measure to display the client's name ( an axis value ), the visual needs to know which client is being selected on the row. You can use an ID field to add the context needed by the visual without supplying a hard name value. Your slicer would then reference a table of client names that is disconnected from the model, i.e) no relationship to your fact table.
This is exactly what I am refering to, thank you. However, I cannot use this measure in the bar chart and when I select a name, the full list of customers (even with no data in the given period) is pulled up.
This is close; however, unfortunately, does not provide the complete solution
parry2k I have around 1k distinct customers that vary throughout months of the year. Ideally I only want to be able to select customers that have purchased in the given period - defined by the period slicer
