User Profile
ClaytonLFA
Frequent Visitor
Joined 1 year ago
User Widgets
Contributions
Re: Issue with Card Visual Layout After November Power BI Desktop Update
Same issue as everyone else, we are approaching the pilot date for our analytics solution and this update broke over 70+ KPI cards across our entire report. Having done extensive troubleshooting they cannot be adjusted to behave similarly to before and the entire project would need to be reworked to accommodate the new card behavior.Conditional Formatting Subtitle - Measure not updating via visual interaction
Hello, I am trying to make a line chart visualization that reports the value in the subtitle. I have tried several different DAX formulas but none of them provide a real-time update when the visual is interacted with. They work seperately as their own visualizations. Is this a limitation of the program or can this functionality be achieved by modifying the DAX or some other setting? ChartSubtitle = CONVERT(FORMAT(IF(HASONEVALUE(data[Sum of Closed Order]),VALUES(data[Sum of Closed Order]),SUM(data[Sum of Closed Order])), "#,##0"),STRING) // SelectedOrders = VAR SelectedOrder = SELECTEDVALUE(data[Month]) RETURN IF( NOT ISBLANK(SelectedOrder), CONVERT(FORMAT(CALCULATE(SUM(data[Sum of Closed Order]), data[Month] = SelectedOrder), "#,##0"),STRING), CONVERT(FORMAT(SUM(data[Sum of Closed Order]), "#,##0"),STRING) ) // SelectedOrderSum = CONVERT(SELECTEDVALUE(data[Sum of Closed Order],data[SelectedOrders]),STRING) As you can see all of these formulas produce the expected visual interaction when the measure is placed in a seperate visual but do not update when used as the conditional formating measure.
