Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

FORMAT - Switch and IF

Hi All,   I need to change my Switch calculation to remove the BLANK() Var = IF (     HASONEVALUE (Swap[Measure]),     SWITCH (         VALUES (Swap[Measure]),         "Sales",FORMAT('Sales'...
General Comment
Interesting Links
Need Help
Tips and Tricks
lbendlin's avatar
lbendlin
Super User
2 years ago

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Anonymous's avatar
Anonymous
Not applicable
2 years ago

lbendlin 

 

Documents

 

Here is a link with sample data and pbix file. As informed, I want to filter on the Date filter and that is not working when I use the format calculation. Thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      lbendlin Thank you, this works for one column. But I have 3 columns with different measures. How can I get the same parameter to swap on different fields? So ideally I would like one parameter.

       

      Documents

       

      Thanks

       

      Please refer to updated data here

       

       

       

       

      But 3 columns in all will have 6 measures to swap and for every column it will be Qty, Sls but different fields. Thanks

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        You can use field parameters for both columns and measures.  

         

        Please provide sample data that fully covers your issue.
        Please show the expected outcome based on the sample data you provided.