how to modify formula from a card

[Anonymous]

hello everyone. (Sorry for the basic question below )

I nned to change the Empty ("En blanco") from this card,  

but I dont remember how to get to formula editor, similar to this yellow part below, to modify the formula to the card

TY for your time

[123abc · Accepted solution]

1. Select the Visual or Field:

   • Go to the report page where your visual is located.
   • Click on the visual (chart, table, etc.) that you want to modify.

2. Access the Fields Pane:

   • On the right side of the screen, you should see the "Fields" pane.
   • If it's not visible, you can open it by clicking on the "View" tab in the ribbon and selecting "Fields."

3. Locate the Field with the Formula:

   • In the Fields pane, find the field that corresponds to the formula you want to modify.

4. Access the Formula Editor:

   • Once you have selected the field, you should see a formula bar at the top of the screen (similar to the yellow part in your screenshot).
   • If the formula bar is not visible, you can make it visible by going to the "View" tab and checking the "Formula Bar" option.

5. Modify the Formula:

   • Click on the formula bar to activate it.
   • Make the necessary modifications to the formula.

6. Apply the Changes:

   • Press Enter to apply the changes to the formula.

7. Verify Results:

   • After modifying the formula, make sure to check your visual to verify that the changes have been applied as expected.

It's important to note that the exact steps might vary slightly depending on the version of Power BI you are using, but the general process should be similar. If you are using Power BI Desktop, these steps should be applicable.

Remember to save your Power BI file after making changes to ensure that your modifications are retained.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

In case there is still a problem, please feel free and explain your issue in detail, It will be my pleasure to assist you in any way I can.

[Anonymous · Accepted solution]

Hi  @Anonymous ,

Based on what you’ve mentioned, to access and modify the formula used in a card visual, you can follow these steps:

Here are my test data:

1.Create a measure to get value based on id

 Measure = CALCULATE( MAX('Table'[Value]), FILTER('Table', 'Table'[ID] == SELECTEDVALUE('Table 2'[ID]) ) ) 

 2.  To modify the formula used in a card visual, you can create a measure like below

 Is Blank = IF(ISBLANK([Measure]), "The value is blank", [Measure]) 

3.When selected value == 3, Initial output

4.Aftrer using the measure Is Blank

In order for you to solve the problem faster, you can refer to the following documentation

How to Get Your Question Answered Quickly - Microsoft Fabric Community

Best Regards,
Albert He

[Anonymous · Accepted solution]

Hi  @Anonymous ,

Based on what you’ve mentioned, to access and modify the formula used in a card visual, you can follow these steps:

Here are my test data:

1.Create a measure to get value based on id

 Measure = CALCULATE( MAX('Table'[Value]), FILTER('Table', 'Table'[ID] == SELECTEDVALUE('Table 2'[ID]) ) ) 

 2.  To modify the formula used in a card visual, you can create a measure like below

 Is Blank = IF(ISBLANK([Measure]), "The value is blank", [Measure]) 

3.When selected value == 3, Initial output

4.Aftrer using the measure Is Blank

In order for you to solve the problem faster, you can refer to the following documentation

How to Get Your Question Answered Quickly - Microsoft Fabric Community

Best Regards,
Albert He

[123abc · Accepted solution]

1. Select the Visual or Field:

   • Go to the report page where your visual is located.
   • Click on the visual (chart, table, etc.) that you want to modify.

2. Access the Fields Pane:

   • On the right side of the screen, you should see the "Fields" pane.
   • If it's not visible, you can open it by clicking on the "View" tab in the ribbon and selecting "Fields."

3. Locate the Field with the Formula:

   • In the Fields pane, find the field that corresponds to the formula you want to modify.

4. Access the Formula Editor:

   • Once you have selected the field, you should see a formula bar at the top of the screen (similar to the yellow part in your screenshot).
   • If the formula bar is not visible, you can make it visible by going to the "View" tab and checking the "Formula Bar" option.

5. Modify the Formula:

   • Click on the formula bar to activate it.
   • Make the necessary modifications to the formula.

6. Apply the Changes:

   • Press Enter to apply the changes to the formula.

7. Verify Results:

   • After modifying the formula, make sure to check your visual to verify that the changes have been applied as expected.

It's important to note that the exact steps might vary slightly depending on the version of Power BI you are using, but the general process should be similar. If you are using Power BI Desktop, these steps should be applicable.

Remember to save your Power BI file after making changes to ensure that your modifications are retained.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

In case there is still a problem, please feel free and explain your issue in detail, It will be my pleasure to assist you in any way I can.

[Anonymous]

Hello 123abc 🙂 thank you for your answer, but I cannot find the step 2, I have this view. what have I doing wrong?

I just have the desktop application.

A few moths ago I could change that part, but now I dont remember how get to that part to change the formula hahaha

thank you for your time

[123abc · Accepted solution]

Here are the steps to switch to the "Model" view and modify a calculated column:

1. Switch to Model View:

   • Click on the "Model" icon in the left sidebar. It looks like a table icon.

2. Locate your Table:

   • In the "Model" view, you will see all the tables in your data model.
   • Find the table containing the calculated column you want to modify.

3. Open the Formula Bar:

   • Click on the table to select it.
   • In the properties pane on the right, you should see a section for "Columns" which lists all the columns in that table.
   • Click on the calculated column for which you want to modify the formula.

4. Modify the Formula:

   • Once you click on the calculated column, you should see the formula in the formula bar at the top.
   • Make the necessary modifications to the formula.

5. Apply Changes:

   • Press Enter to apply the changes to the formula.

6. Close Model View:

   • You can switch back to the "Data" view by clicking on the "Data" icon in the left sidebar.

Please note that in the "Model" view, you'll be able to see and modify calculated columns and measures, while in the "Data" view, you primarily work with the raw data.

If you are still having trouble, make sure you are selecting the correct table and column, and ensure that the formula bar is visible at the top of the Power BI Desktop window.