You are the next level mentor. Always come with complex and beyond the imagination topics. Expecting some more videos on Power BI with Tabular editor combination from you. Really Thanks Man for sharing the knowledge 👍
Hi Bas. Thank you very much. Where is the currency tale please? It would be very useful but can't see it included on the links below your wonderful video. Many thanks
Hi Bas, how are you doing? First of all, thank you for the rich content always. So, I have a situation at my work. I have a lot of KPI to show in a same report, and each measure has a different format type (currency, percentage, general...) I've built a measure using selectedvalue and format to dinamicaly change de format when I select the KPI in the slicer, but, due the fact that FORMAT changes the type to string, I can't use this measure in a chart. Could you help me finding a better solution to this situation, please? Thank you in advance!! :)
Waoo, thank man, you a life saver. Have been looking for way to get this done. But I have an interesting scenario, Is there a way to specify in the Dax which Colum i have the currency to change as the table I have this on filter on as quantity and other numeric values that I don't want the change on
Great tutorial, thank you! I applied and its working great. However, I have 2 visuals on a page. I have applied the currency to the one visual which needs to have a currency applied and the other visual uses a simple number field(no currency). But if I filter the second visual (no currency needed) using the first, then the second visual inherits the currency symbol...any ideas how to exclude? Thanks.
You are the next level mentor. Always come with complex and beyond the imagination topics. Expecting some more videos on Power BI with Tabular editor combination from you. Really Thanks Man for sharing the knowledge 👍
Thanks a ton, really nice to hear! Definitely more to cover on tabular editor :)
Great tips 👍
It can be used for units, thousands(K) millions(M) in same table. We used switch function which dramatically change the currency to text.
Man you rock!. Tabular Editor rocks. This format string expression is a rocket to the Mars! Thank you for your videos!. Have a great day!!!
Thanks a ton- this comment makes my day, really appreciate your support!
Is it possible to do this for cell font conditional formatting to make poistive value blue and negative red ? Thanks
Hi Bas. Thank you very much. Where is the currency tale please? It would be very useful but can't see it included on the links below your wonderful video. Many thanks
This post of yours did great help to me. Thanks a ton. You are awesome.
Thanks Sandip happy to hear it was helpful :)
this will not work on barchart under Column Value, rather it is going under Tooltips section due to Text as datatype, any suggestions on that?
Thank you Bas for the wonderful videos. You make learning fun and interesting.
Hi Bas, how are you doing? First of all, thank you for the rich content always. So, I have a situation at my work. I have a lot of KPI to show in a same report, and each measure has a different format type (currency, percentage, general...) I've built a measure using selectedvalue and format to dinamicaly change de format when I select the KPI in the slicer, but, due the fact that FORMAT changes the type to string, I can't use this measure in a chart. Could you help me finding a better solution to this situation, please? Thank you in advance!! :)
Thank you so much for the video, you are a life save, although I missed your constant smiling in this video 😁
Glad I could help! re smile- noted ;)
This helped a lot thank you great video
Thank you very much for the wonderful videos, they're very helpful! 😁
great to hear! thx Inna! 😀
Waoo, thank man, you a life saver. Have been looking for way to get this done. But I have an interesting scenario, Is there a way to specify in the Dax which Colum i have the currency to change as the table I have this on filter on as quantity and other numeric values that I don't want the change on
Can you show us how to set up for units? If amount > 1 billion, show it as "1.00B". >1 million then show "1.00M". and so on. Thanks
Hi, can I ask you how to change the format of calculation item? I need one of my calculation item in % format, but cannot make it
Great tutorial, thank you! I applied and its working great.
However, I have 2 visuals on a page. I have applied the currency to the one visual which needs to have a currency applied and the other visual uses a simple number field(no currency). But if I filter the second visual (no currency needed) using the first, then the second visual inherits the currency symbol...any ideas how to exclude? Thanks.
Great tips. How about creating different formatting like changing font color, etc at different level of total?
Excellent tip ... thanks
Glad it was helpful!
Good tips!!! Congratulations
Thanks!
Bas is my best virtual colleague :D
Great bro really amazing thanks to share with us bt can you tell me how can we add SSAS TABULAR IN OUR POWER BI
REALLY AMAZING
Literally just install it, if you have a recent version of Desktop. It will then appear in the External Tools menu.
Indian rupees comma format sir