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
Anonymous's avatar
Anonymous
Not applicable
2 years ago

lbendlin Can you please help with above information? I tried creating a sample but it worked fine in it. Also do not see an optio to attach a pbix file in this post

lbendlin's avatar
lbendlin
Icon for Super User rankSuper 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