kpi card
3 Topics
PowerBI KPI Visual
In the last week or two, the KPI visual % variance defaults to showing 2 decimals after publishing it to a workspace, even though it is set to 0 decimals on Desktop. It can't be edited in the workspace either. It was showing the same as Desktop previously, so this seems to be a recent update (Jan-25), has anyone else encountered this? Any ideas for a workaround?Solved2.8KViews0likes13Comments
Issue with DAX Calculation
Hi guys! First of all thanks for reading and helping. Ok, let's suppose i have some price data like this Owner SKU BRAND DATE PRICE DESC RETAIL Company 74258323 A ######## 1180 Prod A WALMART Competitor 14325325 B ######## 3273 Prod B WALMART Competitor 1212434 C ######## 644 Prod C WALMART Competitor 12145346 D ######## 683 Prod D WALMART Company 74258323 A ######## 2154 Prod A WALLGREENS Competitor 14325325 B ######## 1945 Prod B WALLGREENS Competitor 1212434 C ######## 733 Prod C WALLGREENS Competitor 12145346 D ######## 577 Prod D WALLGREENS Company 74258323 A ######## 1742 Prod A TARGET Competitor 14325325 B ######## 1112 Prod B TARGET Competitor 1212434 C ######## 589 Prod C TARGET Competitor 12145346 D ######## 712 Prod D TARGET What i'm trying to calculate via DAX is a Price Index with this custom formula: (AVG Selling Price of my products / AVG Selling Price of my competence) * 100. I have so far this two meassures: ASP_Compete = CALCULATE( [ASP], 'Table'[Owner] = "Competitor" ) ASP_Company = CALCULATE( [ASP], 'Table'[Owner] = "Company" ) And a separate one for the price index wich is: Price Index= DIVIDE(ASP_Comp, ASP_Compete) * 100 From my logic it should work fine, but when i drop into any vissual i got the error: "Error fetching data for this visual: An unexpected exception occurred" Do you know if this is related to an issue of Power BI's version? Thank u again for your answers. RegardsSolved467Views0likes1Comment
How to view previous month as text in a KPI card
Hi, I would like to create a KPI card which shows the previous month as a text. For example, if it is January 2023 today then the previous month should display as 'December 2022' in the KPI card. I tried to use the PREVIOUSMONTH function but the KPI card shows blank. I would appreciate any tips or suggestions. Many Thanks Best Regards RoshanSolved892Views0likes2Comments