Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Cannot load data from this visual
Calculation error in the measurement. A table of several values was provided while a single value was expected
i get this error when i try to create a measure to have the calendar of a specific period
with column paiddate of the table pranking ape
PAIDDATE column is a date type
how can i solve this issue ?
Regards
Hi @Jeffreyjar
sorry for the late reply.
I don't know how your visual is supposed to look like but if you want to return a dynamic set of dates you have two options: either to concatenate the table that contains these days or to place a filter measure in the filter pane of the visual that filters this visual dynamically to the required set of dates.
following is the solution using first option. If you can provide more details of what are planning to achieve I can help you with option 2
dates =
CONCATENATEX (
CALENDAR (
FIRSTDATE ( 'pranking ape'[PAIDDATE] ),
LASTDATE ( 'pranking ape'[PAIDDATE] )
),
'pranking ape'[PAIDDATE],
UNICHAR ( 10 ),
'pranking ape'[PAIDDATE], ASC
)
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 9 | |
| 5 | |
| 5 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 22 | |
| 10 | |
| 9 | |
| 7 | |
| 6 |