Use CONCATENATEX to Create Smart Visuals in Power BI

[@GoodlyChandeep]

⬇Download the Power BI file - goodly.co.in/use-concatenatex-to-create-smart-visuals-power-bi 📊Mastering DAX & Data Modeling - goodly.co.in/learn-dax-powerbi/

[@geineralbertomejiagarzon4034]

Excellent way to explain the CONCATENATEX function and all its features and possibilities. I'm wondering if instead of creating a disconnected table, it would be easier to create a numeric range using a new parameter option. Additionally, another option to prevent the user from selecting more than one option in the "Top Value Selected" slicer is to set the slicer to "Single Select".

[@captivatedCoder]

You could also use that selected value measure to make a dynamic title for the visuals, add that little bit of something extra to the report.

[@padisiva]

It's much more clear for a beginner also Thanks dear

[@namangarg7023]

Neat work can be shown to clients with conditional formatting which u have used in previous videos to highlight cell values as per requirement

[@tubeitz]

love the way you have explained it step by step, thank you.

[@vizwithvipul]

this is awesome

[@xbox4928]

Thank you. Really interesting thing. Also, instead of the calculation column, you can use the parameter (numeric range)

[@gennarocimmino]

Veramente fantastico. Non ci sono parole per ringraziarti di questa condivisione.

[@barttrudeau9237]

Brilliant! That's really taking a basic function to the ultimate application

[@mathsexperts4901]

Hi Mr. Chandeep, you are an excellent teacher. I learnt lots of Power Query tricks and DAX from your KZbin videos and still learning new tricks from every video you've made. I would like to join with your Power Query and DAX courses, however I would like to do a small request. Is there any possibility to join with your course as a monthly subscription. If you would create in such a way it will be really helpful for person who is difficult to spend lots of money at once.

[@HachiAdachi]

👍Thanks, Chandeep! No love 💔for the 'New Parameter' UI button for the dynamic slicer? The effect would be identical, but you would also get the *non-range* 'slider' slicer which is (for some reason) exclusive to a parameter.

[@leemorgan8007]

amazing video as usual - should be able to harness some of this into my reports.

[@faxfax13]

Cristal clear, as usual ! Thank u!

[@faxfax13]

I am thinking about to decline this usage to build « topN and others » Just by replacing « total N » calculation by « total - total N » Looks like very elegant 🤩

[@Giraffe-j3h]

wow the video just keeps getting better and better

[@scotttokaryk3714]

I can use this tomorrow. Thank you!

[@juanignacioXI]

Piece of art there Chandeep!

[@guppi1]

Yep, this is what I looking for. Awesome as always, Chandeep

[@RogerStocker]

U are so crazy dammed awesome! Man! Why can I only give 1👍? you deserve thousands of those.

[@spen2431]

Amazing 👍👍 Thanks for sharing

[@williamkiarie]

nice one, short of words to describe the delivery process. 'nifty' may be 🙂

[@lionels839]

Very pedagogic format Now why not a COALESCE hidden features video if any

[@vacilando86]

What a great short course

[@tinaflemons263]

Brilliant content. Thank you

[@arunwats]

This is really a great trick, lets say we take it one more level to make Top N by dynamic ( By prod name, prod cat, prod subcat etc), how can we do that

[@henrylokrit232]

This is AWWWWESOMMMME👏🏿. 📌

[@prasadraja17]

Just awesome❤

[@timestoryx]

AWESOME !!!!!

[@HemanthKumar-lb4xt]

As usual Awesome!

[@Arif-gn6hl]

Keep up the good work!

[@chrism9037]

Awesome as usual!

[@ExcelWithChris]

Brilliant as always!!!

[@shyjumathew07]

Excellent, thanks

[@josealvesferreira1683]

Very good

[@riazahmedshaik]

nice explanation👏👏👏👏👏👏

[@LAMIAAMOHAMMAD]

Amazing

[@CAKPRashique]

It’s really amazing

[@ronnydegroeve213]

That is awesome ;-)

[@oladman9058]

That’s awesome!

[@vishnupp5944]

Hi Sir Thank you so much for the video. One doubt, In the quarter total line also showing the top products name. is that the best selling product of the entire year (because it is the total of all quarter)?

[@GoodlyChandeep]

Yes, correct

[@TheAlwaysGoel]

Can we use this function in PowerPivot?

[@mrbartuss1]

17:10 Wouldn't it be a better idea to set 'Single Select' on the slicer?

[@MrAbrandao]

Your Videos are fantastic. Why in "Max Prod Sales" you use ALL{Products[Product Code]), why specify the column?

[@GoodlyChandeep]

Its more efficient that way!

[@Sumanth1601]

Brilliant 😮

[@TheAlwaysGoel]

Can you write this function in power pivot same as you write

[@namangarg7023]

👌👍

[@Medsabry98]

خخخ فشيخ

[@williamarthur4801]

Great follow up to your other intro's to the function, one gripe for me, I found UNICHAR does not work in P Pivot, UNICODE does, so you can find out that "A" = 65 , why one and not the other? ( Rhetorical)

[@GoodlyChandeep]

The enter thing works in an excel PowerPivot too but you'll have to use use alt enter within quotes instead of UNICHAR(10)

[@adilumr6359]

Awesome