Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi 🙂
i try to rebuild a Excel Report in powerbi.
i have some KPI (Mesaures) , but i cant display them as in Excel?
here is the Excel:
and this is my result in power bi:
any idea?
Thanx 🙂
Solved! Go to Solution.
To have the measure titles in the rows, you’ll need to access the visualization settings, under the Values option and toggle the option Show on Rows to ON.
To have the measure titles in the rows, you’ll need to access the visualization settings, under the Values option and toggle the option Show on Rows to ON.
@lboldrino , this measure split into measure and dimesion. you need to create table like this with required filter in group by summarize if needed and join back with dimesnions
union(
summarize('Table',"Measure","sales","This period",[SALES YTD],"Last period",[SALES LYTD],"POP",[SALES YOY])
summarize('Table',"Measure","unit","This period",[unit YTD],"Last period",[unit LYTD],"POP",[unit YOY])
)
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
124 | |
79 | |
50 | |
38 | |
38 |
User | Count |
---|---|
196 | |
80 | |
70 | |
51 | |
42 |