Latest Enterprise DNA Initiatives

Charticulator Visual NOT Working

Hi All,

I have been learning to use the new charticulator visual but a couple of days I go I started getting an error message and the visuals would not render in power bi desktop.

Error: dataset incomplete. Please specify all data fields

What am I missing? I have put in all the fields used in creating a simple bar chart but still the visual is not showing in power bi desktop.

Thanks

@Harvey ,

Kind of hard for anyone to advise without posting a sample file. Please post more information so that we can better help you with the issue at hand. Did you build the Charticulator on the website, or the new app that is available in The Desktop. The error message looks like one you would get from building from the website, but hard to tell without a sample file.

Thanks
Jarrett

Uploading: sample file.pbix…
data.csv (203 Bytes)
simplebars.pbiviz (276.1 KB)

I have upload the charticulator viz that is not rendering in power bi.

Thanks

Yes, I have been using the website.

@Harvey Can you share the .Chart file instead?

@Harvey ,

I’ll have a look, but I would suggest using the app that is available on the desktop version of Power BI. That error you got is most common with using the Charticulator website.

Thanks
Jarrett

@AntrikshSharma ,

That error is most common when using the file from the website in Power BI, and the user did not add all of the required fields that were used when building the file on the website.

Thanks
Jarrett

@JarrettM His visual shows a Primary Key field, are you aware of what that is? Since it is isolated from other fields it looks like there is some setting for creating a Primary Key.

@Harvey & @AntrikshSharma ,

File is working fine for me. Here is pbix file.

Jarrett Charticulator Test.pbix (292.3 KB)

Thanks
Jarrett

@AntrikshSharma & @Harvey ,

Here is another copy of the same file, but I added the app within Power BI for the visual on Page 2.

Jarrett Charticulator Test.pbix (2.1 MB)

Page 3 I added a another view that highlights Max Sales in a different color than the rest of the bars.

Thanks
Jarrett

Thanks @JarrettM . But on my power bi desktop it’s not…don’t where the issue is?!

Yes, there’s a primary key field. What needs to go there?

@Harvey ,

Working fine on my version I did. Don’t need primary key. You never posted your orginal PBIX file. Please post it and I’ll have a look. You posted the data and the pbiviz file, but no pbix file. I created a PBIX from scratch.

** The only thing that could be causing the error is the way you have your Total Sales column formatted in you pbix file. Post the pbix, and i’ll see if that is the issue **

Thanks
Jarrett

1 Like

That’s the link to download the file: https://we.tl/t-3zWehvpiIm

@Harvey ,

The issue is with your Total Sales measure. The Charticulator visual you shared & the one that is built into the desktop does NOT like that measure. I did some investigating into the measure, and cannot locate the “Average USD/ZWL Rate” measure. I see a measure for USD/ZWL Rate though?

image

** If that does not solve the issue, the only other option would be to send your PBIX to the Charticulator team at Microsoft. I sent one earlier this week with a similar issue, but have not heard anything back. Email is Charticulator@Microsoft.com

Thanks
Jarrett

3 Likes

Thanks for that @JarrettM . I switched measures and tried the same chart using “Total Quantity” instead of the “Total Sales” measure and it worked well. Could be something in my sales measure, will look into it.

Oh yes, I hid the Average USD/ZWL rate in report view to reduce clutter. If you go to the data tab you can unhide the measure. But yeah, there’s definitely something not right with that calculation. Thanks again for the solution!

2 Likes