Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am trying to create a specific visual to show KPI performance, however I am struggling to build it with the following layout.
Each of the numbers below is a measure in my model, so in the example below I have to put together the 12 measures in this specific format - I'd appreciate any ideas or suggestions.
Thanks,
Solved! Go to Solution.
@mq2020 , You have to create a table like this and display it on matrix
Display Table = union (SUMMARIZE(Sales," Measure", "MTD", "This",[MTD],"Last",[LMTD],"Change",[MOM]),
SUMMARIZE(Sales," Measure", "QTD", "This",[QTD],"Last",[LQTD],"Change",[QOQ]),
SUMMARIZE(Sales," Measure", "YTD", "This",[YTD],"Last",[LYTD],"Change",[YOY]))
For icon formatting
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692
@mq2020 , You have to create a table like this and display it on matrix
Display Table = union (SUMMARIZE(Sales," Measure", "MTD", "This",[MTD],"Last",[LMTD],"Change",[MOM]),
SUMMARIZE(Sales," Measure", "QTD", "This",[QTD],"Last",[LQTD],"Change",[QOQ]),
SUMMARIZE(Sales," Measure", "YTD", "This",[YTD],"Last",[LYTD],"Change",[YOY]))
For icon formatting
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692
@amitchandak , the layout is working perfectly, thank you.
However the measure doesn't seem to be shwoing the calculation according to the filters used in the dashboard.
Any way I can work around this? i.e in the filter visual I select a specific country but the table will still show the total number.
Thanks,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |