kpi matrix
3 TopicsRename values in a measure and use it as a row in matrix
Hello, I work on Power BI with Direct DB Connexion. I wanted to just rename values contaned in a column, and display it in a matrix as a row. For a translation for example. SPA = If selectedvalue(ENG)= "Flower", "Flores In a table, it works: ENG | SPA | Number Flowers | Flores | 18 But it does not allow me to use SPA as a row in a matrix. Can I get it to work somehow?Solved1.4KViews0likes4CommentsPower KPI Matrix formatting lost on data update
I'm having an issue where my custom formatting is lost when I get new data. I have a SQL datasource that is formatted to the template and a couple stored procedures that pull in new data daily. I have 12 KPIs on a page and half have custom formatting other than a 1 decimal percentage, but when the new data comes all formatting is reverted back to a 1 decimal percentage. I do have a column stored where I could drop in the type of formatting I want, but that doesn't appear to be an option. This has been happening for a while and everytime Management wants to view the report I need to manually change the formatting back. Also we're on version 3.1.1.0. Thanks1KViews0likes0Comments