OMG THANK YOU! I have literally been stuck on this for days. I must have gone through every piece of documentation and every single forum post from EVERY forum that had anything remotely related to formatting in vega-lite and/or Deneb. Thank you so much for posting this!!!!
Asked and answered! This was driving me crazy but with your help I was able to get this to work with my calculation groups. In my particular case there were many measures and just two formats so I created a dax column to mark when I should use each format to help simplify the vega lite and used the filter technique. I was not able to use your first method but I will keep trying. Keep these Deneb videos coming!
So pleased this helped. Yeah I much prefer doing it by filtering, but I suppose if you have multiple it could be a lot. Maybe filtering and using does not equal rather than equals could make it easier?
Thank you for the video! I had a follow up: is there a way to pass the formatting option selected in the powerBI selection menu to the Deneb chart? For example, if we select "format" to be "percentage", we can see when we hover over the Deneb bar chart it does change the values to percentage, but it does not show up in the actual visualization. Cheers!
Thanks. Yeah, I was thinking about this. I have a few Deneb videos, but not in a massively structured format as you mentioned. I'll have to think about the best way I could do this.
Thanks for your time Ben! Second method is definitely great, but for simple cases first could be OK because I suppose you can make a double condition like: "calculate": "datum.Number =0? format(datum.Number,'.1%') : datum.Number" can't you?
That's right. I didn't use this in the video, but you can use the double condition as you stated. Here is a good example of that. stackoverflow.com/questions/68808216/how-to-use-conditional-statements-in-vega-lite-transform
Hi, Really appreciate your work, you are doing great help teaching how to create custom visualization with Deneb. Learnt many things watching your videos. Again got struck with once of requirement, felt helpless and reached you channel. I want to Concat text with number formatted to show K(thousands), M(Millions). want to show "1.0M (Last Qtr)" and when values are in Thousands dynamically it should change let say "970 K(Last Qtr) can you please help me on this Thanks in Advance
To format in GBP in millions "format": "£#,,.0M", "formatType": "pbiFormat" , To format in GBP comma separated and full number "format": "£#,0", "formatType": "pbiFormat" ,
OMG THANK YOU! I have literally been stuck on this for days. I must have gone through every piece of documentation and every single forum post from EVERY forum that had anything remotely related to formatting in vega-lite and/or Deneb. Thank you so much for posting this!!!!
So pleased it helped you. 🙂 Though the Vega-lite documentation is excellent, I think it often falls short with text related issues.
Asked and answered! This was driving me crazy but with your help I was able to get this to work with my calculation groups. In my particular case there were many measures and just two formats so I created a dax column to mark when I should use each format to help simplify the vega lite and used the filter technique. I was not able to use your first method but I will keep trying. Keep these Deneb videos coming!
So pleased this helped. Yeah I much prefer doing it by filtering, but I suppose if you have multiple it could be a lot. Maybe filtering and using does not equal rather than equals could make it easier?
Thank you for the video!
I had a follow up: is there a way to pass the formatting option selected in the powerBI selection menu to the Deneb chart? For example, if we select "format" to be "percentage", we can see when we hover over the Deneb bar chart it does change the values to percentage, but it does not show up in the actual visualization. Cheers!
You're the man!
Awesome, how about have a series of videos which can take the individual from beginner's to intermediate and then to Advance in Vega / Deneb?
Thanks. Yeah, I was thinking about this. I have a few Deneb videos, but not in a massively structured format as you mentioned. I'll have to think about the best way I could do this.
how can I change the thousands separator from ',' to '.' ?
Good question. I will try to do a video on that asap.
@@PowerBIFerryTales It will help me a lot!
Thanks for your time Ben!
Second method is definitely great, but for simple cases first could be OK because I suppose you can make a double condition like:
"calculate": "datum.Number =0? format(datum.Number,'.1%') : datum.Number"
can't you?
That's right. I didn't use this in the video, but you can use the double condition as you stated. Here is a good example of that.
stackoverflow.com/questions/68808216/how-to-use-conditional-statements-in-vega-lite-transform
Hi,
Really appreciate your work, you are doing great help teaching how to create custom visualization with Deneb. Learnt many things watching your videos.
Again got struck with once of requirement, felt helpless and reached you channel.
I want to Concat text with number formatted to show K(thousands), M(Millions).
want to show "1.0M (Last Qtr)" and when values are in Thousands dynamically it should change let say "970 K(Last Qtr)
can you please help me on this
Thanks in Advance
To format in GBP in millions
"format": "£#,,.0M",
"formatType": "pbiFormat" ,
To format in GBP comma separated and full number
"format": "£#,0",
"formatType": "pbiFormat" ,