MAQ Dot Plot – Custom legend colors not working when selected value has no data (blank)
Hi Team, I am working on a MAQ Dot Plot visual in Power BI Dashbaord where I compare one selected company against a cohort of multiple company's I am using two disconnected slicers one for a single selected company and another for multiple cohort company's. I created a DAX measure that checks if the current row’s company belongs to the selected slicer or the cohort slicer using VALUES and IN logic. Based on this, I return a flag (1 for selected, 0 for cohort) and use it in the visual for conditional formatting and filtering 1. Scenario / Requirement Selected company (single select) Cohort company's (multi-select) Requirement: Selected company → highlighted in Orange (#ED7D31) Cohort company's → shown in Blue (#2994C7) Selected company has NO data → Treat as cohorts blue color (#2994C7) Legend Calculation: I am using the following DAX for legend: School Selected = VAR SelectedValues =VALUES('Slicer Selected company '[Selected company]) RETURN IF(MAX(Selectedcompany[companyName]) IN SelectedValues,1,0) Issue: This setup was working correctly earlier. However, recently I have noticed a change in behavior. When the selected company has no data (returns blank), the visual removes that data point and only cohort data remains. In this situation, the MAQ Dot Plot no longer applies the expected cohort color and instead defaults to a grey/black color. However now: When the selected company has no data (blank) That data point disappears (expected) But then the visual shows only cohort values, legend collapses into a single category and all dots turn default grey/black instead of blue 👉This breaks the custom color logic. Observed Behavior: If selected company has data → colors work correctly If selected company has NO data → Only cohort remains visual shows default grey/black color. Additional Details: Using numeric legend (1 / 0) for color mapping Gradient coloring Minimum color Blue (#2994C7) and Maxnimum color Orange (#ED7D31) Tables are partially disconnected (using DAX logic for filtering) My Understanding: It seems that: When selected company has no data, the measure returns BLANK Power BI removes that row Only one legend category (0 = cohort) remains MAQ Dot Plot fails to apply custom colors and defaults to grey Question's: Is this expected behavior in MAQ Dot Plot when only one legend category exists? Have there been any recent updates or changes in Power BI or the MAQ visual that could have affected this behavior? How can I: Maintain custom colors even when selected data is missing? Prevent fallback to default grey color? Is there a recommended way to always preserve legend categories in MAQ visuals? Please any guidance or best practices would be greatly appreciated. Thanks, Pradeep
Get the average of a column value based on total count of values in ID column
Hi, In a table i have column called "Object" which runs multiple times in a day and that runtime is captured in "StartTime" & "EndTime" columns, and the difference between the start and end time is captured in the "Duration" Column. Each object will be having multiple runid's which is captured in "RunID" column which is a unique value. For eg: Object AAA has two runid's called "111,222" and Object BBB has one runid called "333". Now i would like to get the average of each duration by count of that particular runid which is captured in "New Duration" column. For eg: The count of 111 runid is '10'. so for all those durations with runid 111 should be divided by the 10. The count of 222 runid is '6'. so for all those durations with runid 222 should be divided by the 6. The count of 333 runid is '8'. so for all those durations with runid 333 should be divided by the 8. Sample screenshot for above query: So since my Duration is "10" and total count of runid (111) is 10. So 10/10=1 that is my newduration.Similarly for all durations with runid's 111 should be divided bt 10. How to achieve this using DAX query?? I am connecting to this table in powerbi via SQL direct query mode. Thanks.
PBI Live connect to AAS (dynamic columns in matrix) ?
Hi all, Iam in trouble with creating matrix in PBI which will dynamically change columns/rows based on selection from slicer. Iam using live connect to Azure analysis tabular model actually and trying to do following solution: static data table for colum names, measure to identify change, row_selector:=sum('Value selector row'[Order]) calculated column "rows" = var x1=IF([row_selector]>39,1,[row_selector]) var x2= CALCULATE(VALUES('Value selector row'[Name]),FILTER('Value selector row','Value selector row'[Order]=x1)) return switch( x2, "Stredisko",RELATED('xy1'[x)]), "Prevádzka",RELATED('xy2'[y)]), "Pokladňa",RELATED('xy3'[z]), "N/A" ) In AAS visual studio is everything working fine, but after deploy to PBI row value is not changing either when underlying measure changes correctly. Is there some way to refresh calculated colum when PBI (live connected) slicer selection changes ? Thank you
