User Profile
ImaKickUrBut
Frequent Visitor
Joined 1 year ago
User Widgets
Contributions
Re: How to deselect visual table rows with a button
Thank you danextian! this solves my table record de-selecting issue. Is there a way to clear all slicers AND delselect the table visual records? the bookmark resets all the slicers & sets the visuals back to their original state for the most part, but a user typed some letters in a slicer search dropdown & bookmark does not clear that text, but clicking a 'clear all slicers' action button does. is it possible to add both bookmark & clear all slicers actions to a button?1.7KViews0likes0CommentsRe: How to deselect visual table rows with a button
Hi FreemanZ , thanks, I have a 'clear all slicers' (labeled clear all filters) button but it doesn't deselect table rows. Is there a potential solution with bookmarks mentioned in the https://learn.microsoft.com/en-us/power-bi/create-reports/buttons-apply-all-clear-all-slicers?tabs=powerbi-desktop article? I haven't used the bookmarks feature yet!1.9KViews0likes0CommentsHow to deselect visual table rows with a button
Hello! I have a couple of cross-sliced table visuals with a medium amout of rows and my users are getting confused about why the "Clear All Filters" button clears slicers but doesn't de-select table rows. They don't always realize when they have a row selected, so they submit trouble tickets because they can't find the additional related rows and think there's data missing, but they just need to scroll to & deselect a table row. Is there a way to deselect table visual rows with a button? or is there another on-page approach to reset tables to their un-selected state? Thanks in advance!!Solved1.9KViews0likes4CommentsAdd column to Merged Query when sub query contains text
Hello! I'm very new to PBI & need some guidance please. I have 2 queries, queryA & queryB - these queries are joined on recipeid. example: queryA recipeid recipename recipedate queryb 12345 apple pie 1/1/2024 Table 99999 banana pudding 2/1/2024 Table 654654 chocolate cake 3/1/2024 Table queryB recipeid ingredientname 12345 apples 12345 butter 12345 sugar 99999 bananas 99999 milk 99999 nilla wafers 654654 chocolate 654654 butter 654654 even more chololate *I want to keep query a to one row for recipe id, with adding a new column that will return true or false based on the presence of "butter" in the queryb.ingredientname field where the recipeid matches. example output: queryA recipeid recipename recipedate hasbutter 12345 apple pie 1/1/2024 true 99999 banana pudding 2/1/2024 false 654654 chocolate cake 3/1/2024 true what's the best way to accomplish this please? thanks in advance!Solved1.2KViews0likes6Commentsreference column value from before Table.Combine step
Hello! I'm very new to PBI & need some guidance please. I am combining 6 excel workbooks together - each workbook has several sheets that show departments & items based on item status (intake or inventoried). Workbook Sheets: department1-intake, department1-inventoried, department2-intake, department2-inventoried, etc * if departments dont have any intake or inventoried items, the sheet is not present in the workbook the only place that the workbook shows the department & activity is in the sheet name. I am using Table.Combine to create a single aggrigated table from all the workbooks, but I'd like to show a column with the department and activity in the aggrigated table. What would be the best way to show which sheet (department & activity) the data came from? Could I reference the origin sheet name in a column?Solved397Views0likes1Comment
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.