Forum Discussion

anusha_2023's avatar
anusha_2023
Icon for Helper IV rankHelper IV
2 years ago
Solved

Remove rows based on the button click

I have a Resource table which is connected to facts booking table and Date Table. Need to create a button called "Clear Specialist data". I want to have a button in the report to remove data for Reso...
  • anusha_2023's avatar
    anusha_2023
    2 years ago

    I have tried a work around with creating a calculated column with fileds to show unassigned and not unassigned and filter on the visual to show the appropriate check box in order to filter the resource names. Thank yo very much for your detailed steps

123abc's avatar
123abc
Icon for Community Champion rankCommunity Champion
2 years ago

t seems like you're trying to create a measure that checks if a resource name contains "* Unassigned". The DAX measure you provided is correct for that purpose.

However, if you are not able to see the measure in the "Values" field when adding the button in the visualization pane, it could be due to a few reasons. Here's a step-by-step guide on how to add a button with the measure:

Step 1: Create the Measure

 

IsUnassigned = IF(MAXX(FILTER('Resource', SEARCH("* Unassigned", 'Resource'[Name], 1, 0) > 0), 1), 1, 0)

 

Step 2: Add a Button Visualization

  1. Go to the "Home" tab.
  2. Click on "Text box" from the "Home" tab's "Home" ribbon.
  3. A new text box will be added to your report.

Step 3: Edit the Button

  1. With the text box selected, go to the "Visualization" pane.
  2. Drag the "IsUnassigned" measure to the "Values" field in the "Visualization" pane.

Step 4: Configure the Button

  1. In the "Fields" pane, you should see the "IsUnassigned" measure under "Values."
  2. Configure the text box to display the result of the measure (1 for true, 0 for false).
  3. Customize the appearance of the text box to make it look like a button.

Step 5: Set Actions for the Button

  1. Right-click on the text box.
  2. Under "Action," choose "Bookmark."
  3. Select the appropriate bookmarks for showing/hiding Unassigned data.

Step 6: Test the Button

Click on the text box/button to see if it toggles between showing and hiding the Unassigned data.

If you're still having trouble, double-check that the measure is created in the correct table ('Resource' table in this case) and is visible in the "Fields" pane. Also, ensure that your button is correctly configured to use the measure. If you encounter any issues, feel free to provide more details, and I'll be happy to assist further.

 

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.

anusha_2023's avatar
anusha_2023
Icon for Helper IV rankHelper IV
2 years ago

Thanks for the detailed steps again. For the third step I could not see values in visualization pane for text box and in format pane i could not see the Action option too. Below are the screen shots.

 

 

But if i gave the measure in the value as shown below I am getting 1 as display. If that is what you mean to set the ction for this textbox as I could not see any Action in the Format option.

 

Step 3: Edit the Button

  1. With the text box selected, go to the "Visualization" pane.
  2. Drag the "IsUnassigned" measure to the "Values" field in the "Visualization" pane.
  • anusha_2023's avatar
    anusha_2023
    Icon for Helper IV rankHelper IV
    2 years ago

    I have tried a work around with creating a calculated column with fileds to show unassigned and not unassigned and filter on the visual to show the appropriate check box in order to filter the resource names. Thank yo very much for your detailed steps