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'm trying to create a Manual Metric for which someone from my team would periodically log in and add a new value manually. I have a spreadsheet of past dates and values for the metric, and I'd like to initialize the metric so that it has this history.
In Power BI Service when editing my metric, I go to "Edit multiple values..." and that pops up a dialog that says I can paste multiple dates and values.
But when I try to copy/paste a formatted table of dates and values from a spreadsheet, it just populates the first cell and it doesn't add multiple rows. I've tried many variations of date formats, one column at a time, etc... but can't get anything to work.
I'm expecting that I can copy my historical data, paste it into this interface, and be able to bulk-add many rows of (value, date).
It seems like this is broken for me, so I'm curious if it's working for anyone else, and if so, what exactly are you doing to get it to work?
I'm using a recent version of Google Chrome on macOS to access Power BI Service.
Thanks for any assistance in advance!
Hi,
The way I got this working is by formatting the dates using locale English (United States) in Excel and then simply pasting to the top left cell in Metrics.
-Lasse
Bumping this because it seems that it's still broken. I'm wondering if I'm doing something wrong or if there's perhaps a clever workaround — is this working for anyone else right now?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
41 | |
26 | |
24 | |
19 | |
17 |
User | Count |
---|---|
52 | |
42 | |
24 | |
21 | |
20 |