Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dynamic Drill-down with ISFILTERED; Modify bar chart axis dimension

Hello, I am trying to determine what needs correction to make this formula/function work.  Or if I need to do something completely different.     I have 4 separate filters that break the US into r...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I'm really trying to get help with the IF statement.  I feel like the IF statement only works with numerical values and text.

 

For example IF( expression, 1, 0)  or IF( expression, "One", "Zero").

 

Can you not write something like IF( expression, [Dimension], [Other Dimension])

 

In this situation the dimensions are the States in the US and the Regions in the US.

 

I'm guessing I can create a table with All the states and 1, 2, 3, 4 etc.  Join the table and write a statement, but that seems overly complex.  

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ，

     

    Could you pls upload your .pbix file to onedrive business and share the link with us(remove the confidential information)?

    I would try to test for you.

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!