Issue with slicer selection

[Anonymous]

Hi Experts,

Please help me to resolve this issue. bar chart is only enable if i select Visitors from column metric (pic 1),  but not for others (pic 2)

[Anonymous]

@Anonymous 

Try this,

If(selectedvalue(table[Column])="Visitors",value1,0)

Add this measure to visual level filter and set it to not 0.

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

[Anonymous]

Sir, As you mentioned i have set the filter to 0 but its not working.why i am getting result like this, i dnt have any idea.

hour from date table, walkin from fact 1 and result from facts 2.

Facts 1 and Fact 2 have 1:M joins with date table crossfilter join (BOTH)

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may apply virtual relationship in DAX measure.

• https://www.sqlbi.com/articles/physical-and-virtual-relationships-in-dax/
• https://community.powerbi.com/t5/Desktop/Use-a-date-slicer-to-filter-on-a-period-instead-of-a-single...