User Profile
adoster
Resolver I
Joined 4 years ago
User Widgets
Contributions
Re: Create AND/OR filtering
Thanks for the suggestion but may be I did not explain properly. There are 2 existing slicers on screen for Column A & B with Yes/No values. Then I need a 3rd slicer with the ability to adjust count between AND/OR values of slicers on screen (scalable to many more slicers). Yolo Zhu offered a decent workaround for a couple slicers and I'll submit an idea for further functionality.1.2KViews0likes0CommentsRe: Create AND/OR filtering
While this technically works it requires a new table for every slicer which at scale is cumbersome. I have about 10 values at this time requiring an AND/OR option so this may work short term, but likely will submit an idea for this type of functionality to be implemented similar to what Tableau offers unless there is an alternative solution. Thank you for this workaround.1.2KViews0likes0CommentsRe: Create AND/OR filtering
RecordNum ColumnA ColumnB 1 Yes No 2 Yes Yes 3 No Yes Both slicers set to Yes, AND Count = 1 Both sliicers set to Yes, OR Count = 3 I would like a slicer on screen with AND or OR values to switch between these but also this needs to be scalable across many column, not just 2.1.3KViews0likes2CommentsCreate AND/OR filtering
I have 2 columns in my table with Yes/No values. I have built 2 slicers for each column. If both slicers are set to Yes, I would like a 3rd slicer with AND or OR values to switch between the records. This is the way I've tried to resolve this unsuccessfully. If I should be going about it another way let me know. I feel like i'm missing something basic here. I created a new table AND_OR = GENERATESERIES(0, 1, 1) I created a measure ANDORFILTERING = VAR AndOr = SELECTEDVALUE('AND_OR'[Value]) VAR AndResult = IF(COUNTROWS(FILTER('All Data', 'All Data'[ColumnA] = "Yes" && 'All Data'[ColumnB] = "Yes")) > 0, 1, 0) VAR OrResult = IF(COUNTROWS(FILTER('All Data', 'All Data'[ColumnA] = "Yes" || 'All Data'[ColumnB] = "Yes")) > 0, 1, 0) RETURN IF(AndOr = 0, OrResult, AndResult) I then set this measure on my table with a value = 1. My values do not change using this method when switching between AND/OR. Thanks for any assistance.Solved1.4KViews0likes6CommentsRe: Power BI May Version: publish button does not appear!
Just to clarify we hit the ESC button to close the Publishing window. Then click publish again and it was fixed. This worked for all our users in our environment but perhaps isn't a global fix. Also this has to be done on each file.2.3KViews1like0CommentsRe: Slicer (new) fix Sync Slicer option
I don't know if there will be any kind of notification or update on this page or somewhere else when fixed, but not being able to Sync a slicer across pages makes this pretty much useless even for testing purposes. I had to revert back to Chiclet Slicer for my dashboards. Thanks for the update though.681Views0likes0CommentsRe: Show Parameters across 2 visuals using 1 Slicer
I was able to work out a solution to this. Step 1: Create a reference table DimCompliance = DATATABLE( "MeasureName",STRING, "ID",INTEGER, { {"Height",1}, {"Weight",2}, } ) Step 2: Create 2 Switch Measures CountSwitch = SWITCH ( SELECTEDVALUE ( DimCompliance[ID] ), 1, [CountHeight], 2, [CountWeight] ) ComplianceSwitch = SWITCH ( SELECTEDVALUE ( DimCompliance[ID] ), 1, [ComplianceHeight], 2, [ComplianceWeight] ) Step 3: Create 2 visuals using Switch Measures320Views0likes0Comments
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.