#powerbi #powerbitutorials #powerbiforbeginners #powerbidax #dax This is Power BI tutorial channel for all Power BI enthusiasts.We also help with Power BI interviews & learnings. Lets help each other in building a better Power BI community. Do subscribe to my channel and encourage me with your likes and comments which will in turn energize me to build better Power BI content. Thanks!
little simple way to avoid any confusion between the currency and percentage, we can use the below dax to create calculated column Output = FORMAT(Sheet1[Mixed], SWITCH(Sheet1[Type], "Decimal", "$00.00", "Percentage", "00.00%"))
not only hiding the filters pane..we have an option where we can lock the filters at the visual level and the page level so that once you publish the report to the power bi service and share the report with others..they will be able to see the filters pane but they will not be able to edit the filters or modify the filters...
extension to the above question where we need to display the country name when you select a country in the slicer.. if you need to display list of countries by a delimeter when you choose multiple countries in the slicer, use the below dax expression in the measure, Selected Countries = VAR _countriesList = CONCATENATEX(DISTINCT(Sheet1[CountryName]), Sheet1[CountryName], ", ") RETURN SWITCH(TRUE(), ISFILTERED(Sheet1[CountryName]), _countriesList, "Please Select Country To Display")
to clear the filters for all the slicers we can a new option available in power bi...where we can go to the actions of the image object and select the type as "clear all slicers"
thnx ..yes it was introduced recently ..i will try to make a video on this ..thnx for being vigilant & pointing out Madhusudhan .Also, If you like my content do subscribe .Bye.:)
@@powerbizone Always welcome!!!! I know the pain it takes to create these videos to help the community and share the knowledge...All the best for future videos
The link to download the file : drive.google.com/file/d/1-wg3TDunOhgolKKqeGAjEKldcwy9xdd-/view?usp=sharing Do not forget to subscribe to get all the latest updates ,tricks & tricks on power BI.
Thank you for the comment Kajori..Really appreaciate your interest .However i have close to 50 videos now with diverse topics .To combine everything into a single project is going to be a mammoth task .Nevertheless i am creating Playlists so that viewers can get different useful topics under one umbrella.I will defeinitely try to make a long video on Power BI in the upcoming future .Thanks for your commment and dont forget to subscribe :)
Sure ..Here you go: drive.google.com/file/d/1-wg3TDunOhgolKKqeGAjEKldcwy9xdd-/view?usp=sharing Also bro..if you like the content dont forget to subscribe :)
Very nice. This may very helpful in my project as i am working on finance project. We can use min and max word rather than putting high or low values. Bcz i am using this thing.
❤❤Do not forget to Like ,Subscribe and comment which keeps me motivated !🔥🔥 Mail your Queries at : yourpowerbizone@gmail.com Download the pbix from: drive.google.com/file/d/15Hh7LpgLR2g6UFCZrNdmkiRa-yzXRbJU/view?usp=sharing
Suppose I have 2 preselected slicers product and month dependent on each other, On selecting a product from the product slicer i get the default minimum month selected on the month slicer, when I change the selection on the month slicer manually, and now I go back and select another product on the product slicer, the default on the month slicer vanishes, nothing is selected by default. I need to reset and get back the default selection. Can this be avoided? I mean I do not want to use the reset button.
Hey there .thnx for trying this out.There can be multiple ways to achieve the same objective.However it depends on you which method you want to choose .If you think you are comfortable with the chatgpt output .please go for it .All the best !
Hi, thank you for the video, I have a question , let us say I want to exclude both the filters in the table shown. Can we do that. So the formula would be AllSales = calculate( sum(financials[Sales]), all(financials[country]), all (financials[year]) I am assuming that year column belongs to the 'financials' table. is it possible to add 2 or more filters in the all function calculation?
I have a similar goal to the tutorial you provided; however, in the case if you were to filter out a country like united states, I would like the cumulative total to start at the next highest country. Could you provide insight to how that can be done? Many thanks!
i am trying to understand these filters from many tutor & videos but this videos made my day, i am able to understand everything. Thank u so much @PowerBI Zone
For the scenario 2 and 3, Can you please tell....What if they wanted the result to be dynamic, means if they changes the order of the columns in the visual, the measure should automatically return the first non blank value without changing the measure again and again, is this possible ?
