Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Issue with slicer selection

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)

v-chuncz-msft
6 years ago
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...

3 Replies

Anonymous
Not applicable
6 years ago
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
  Not applicable
  6 years ago
  
  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
    Community Support
    6 years ago
    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...

Related content