![Power BI Helpline](/img/default-banner.jpg)
- 136
- 989 485
Power BI Helpline
India
Приєднався 6 лип 2022
Get Help into Questions Related to #PowerBI , #DAX , M Code, Power BI Data Modeling, Analysis Service Model and Power BI Service .
Our videos are mostly specific to real time challenges faced into Power BI projects and its solutions. We use smart and most efficient techniques to solve such challenging situations in Power BI and DAX.
Checkout our playlist and SUBSCRIBE to our channel, for all such interesting topics in Power BI.
Our website's blog posts.
www.powerbihelpline.com/resources
Our videos are mostly specific to real time challenges faced into Power BI projects and its solutions. We use smart and most efficient techniques to solve such challenging situations in Power BI and DAX.
Checkout our playlist and SUBSCRIBE to our channel, for all such interesting topics in Power BI.
Our website's blog posts.
www.powerbihelpline.com/resources
Dynamic Rank range Slicer in Power BI| Select Dynamic Ranks from Slicer
Creating Dynamic Rank slicer on the report page is tricky. Because to create a slicer you need to add it as column. And there you can have Static Ranks. In this video, we are going to create a fully Dynamic Rank range Slicer Which will Dynamically change the products for same ranks and can be easily used as a slicer on your Power BI reports.
Get Help into Questions Related to #powerbi, #dax, #powerquery Power BI #datamodeling, #analysisservices and #powerbiservice and #microsoftfabric
Check out our website www.powerbihelpline.com and blog-post. for end-to-end power BI solutions, Power BI templates, or any kind of Power BI questions like Power query errors, Authoring and optimizing DAX codes for complex business logic.
Follow us on LinkedIn
www.linkedin.com/in/power-bi-helpline-22a2a2244
Email- info@pbihelpline.com
@PowerBIHelpline
Get Help into Questions Related to #powerbi, #dax, #powerquery Power BI #datamodeling, #analysisservices and #powerbiservice and #microsoftfabric
Check out our website www.powerbihelpline.com and blog-post. for end-to-end power BI solutions, Power BI templates, or any kind of Power BI questions like Power query errors, Authoring and optimizing DAX codes for complex business logic.
Follow us on LinkedIn
www.linkedin.com/in/power-bi-helpline-22a2a2244
Email- info@pbihelpline.com
@PowerBIHelpline
Переглядів: 977
Відео
Dynamic Hierarchy in Column Header | Customize your Matrix Visual in Power BI
Переглядів 1,6 тис.Місяць тому
Many times we get the requirement to show different levels in matrix column header only for few fields, or only for selected fields in the slicer. In this video, we will show a solution, where the Matrix column header will show further drilldown only for the selected fields in the slicer, and for remaining fields it will show the aggregate values. Get Help into Questions Related to #powerbi, #d...
Dynamic Column Header with Multiple Measures in Power BI | Table and Matrix Visual Power BI
Переглядів 4,4 тис.2 місяці тому
As we know that measure names are static, but many times we need to show dynamic column header names in table or matrix visuals, which changes based on slicer selection. Field parameter is not the solution for this particular requirement. In this video, we are going to create a solution to show time intelligence measures with selected month names as the column header of our matrix visual. Get H...
Data Driven Email Subscription in Power BI | Conditional Email Alert for Power BI Report
Переглядів 3 тис.3 місяці тому
In this video, We are going to create a solution, where data driven email alert with screenshot of the report page will be sent only to those store managers where total sales amount is less than the total forecast value. We will use some Dax technique with new dynamic subscription, and will convert this email subscription into fully dynamic and conditional email alert system Get Help into Quest...
Variance between 2 from SAME SLICER in Power BI | Compare 2 values from Same Slicer
Переглядів 3,1 тис.4 місяці тому
In this video, we will create a solution to compare 2 selected values from the same slicer. All our visuals will only show when we select any 2 values from the slicer, else it throws a popup message, saying that you have selected these many number of values, please select only 2 to compare. Get Help into Questions Related to #powerbi, #dax, #powerquery Power BI #datamodeling, #analysisservices ...
Table Visual with Small Multiple and Variance Arrows | Native Power BI Visual | New Power BI feature
Переглядів 3,2 тис.5 місяців тому
We have got many amazing new features in Power BI native visuals, which we can utilize to create such visuals. In this demo, I am going to utilize new features like, Overlap option, Custom data label and error bars, to create a table like visual, which will also show small multiples. Get Help into Questions Related to #powerbi, #dax, #powerquery Power BI #datamodeling, #analysisservices and #po...
Conditional Formatting for Stacked/Clustered Column Chart in Power BI | New Power BI feature
Переглядів 12 тис.5 місяців тому
With Power BI Native Clustered/Stacked Column chart or Bar chart, we know that we don’t get Conditional Formatting features. But with This new Feature and a simple DAX trick we can actually achieve dynamic color formatting for one of the columns in a stacked column chart. Or we can dynamically apply different colors to a series in the Stacked column chart or Bar chart. This video will answer be...
Issue with Last Refresh Date/Time in Power BI
Переглядів 6 тис.6 місяців тому
If we create a query inside Power query editor with DateTime.LocalNow() function to get Last refresh date/time, then there is a very big problem. This almost gives the refresh Start time, because this individual query is very smalls. And if your dataset takes much time to complete it’s refresh, then result of above query is not much useful. Til now we were looking at the TimeZone conversion, bu...
New Dynamic Email Subscription/Alert for Power BI Reports | Power BI Update Jan 2024
Переглядів 2,8 тис.6 місяців тому
We now have new feature in Power BI service in the section of Email Subscription for report pages. Where we can dynamically filter the reports using defined filters in a separate table. And send email alerts to different set of users. In this video I will walk you through, how to enable this functionality. This video will answer below query- - Dynamic Email Subscription/Alert For Power BI Repor...
Column Chart Makeover with New Power BI features | Dec 2023 Power BI Updates for Column/Bar Charts
Переглядів 4,4 тис.7 місяців тому
In this video we will use December 2023 Updates of Power BI desktop, which brought many new features for column or bar charts formatting. It has Borders for columns, Title and Details for data labels. Let’s use these features with some tricks to make our column chart even more impressive. Get Help into Questions Related to #powerbi, #dax, #powerquery Power BI #datamodeling, #analysisservices an...
New way of Add/remove Dynamic fields | Create Colorful Checkbox and toggle with New Power BI Slicer
Переглядів 3,9 тис.7 місяців тому
In this video, we will use new Power BI slicer to create the amazing slicer experience with colourful checkboxes and toggle. We can Dynamically add or remove fields from the visuals using such slicers. By adding Field parameter and some DAX tricks. To create the required measures, we will also utilize the newly added Copilot in Power BI desktop. Please note that, we are using here Dummy data to...
Dynamic Column Names with Multiple Measures in Power BI Matrix or Table Visuals
Переглядів 7 тис.8 місяців тому
We use Field parameter to dynamically change the fields, but in case of multiple measures in the Table/Matrix visual, how can we dynamically change all the column names. Let’s find out 2 easy solutions for this particular problem. Get Help into Questions Related to #powerbi, #dax, #powerquery Power BI #datamodeling, #analysisservices and #powerbiservice and #microsoftfabric Check out our websit...
Solve Data Export and Drill Through Problem for YTD QTD & MTD in Power BI
Переглядів 1,8 тис.8 місяців тому
Many Times, we create a drill through page to get detailed information of underline data, but with a value which show YTD or QTD, Month Drill Through may not show all the relevant information, because drill through page will be filtered only for the selected month. In this video We will Provide a solution for this particular problem. Which could be very useful in Data Export or drill through of...
Previous Year, Current Year YTD & Future Months Forecast in Power BI | Dynamic Axis in Column Chart
Переглядів 4,1 тис.9 місяців тому
Yes, Power BI Native Column charts can be modified to show amazing visualizations. In this example, we will create a visual which will show a single bar for Previous year value, then A single bar for the current YTD values, and then it will show you the future months forecast values along with cumulative sales amount below it. This visual can be very useful in many of your financial reporting P...
Slicer Controlled Color Properties in Power BI | HSLA Slicer in Power BI | Dynamically change Color
Переглядів 1,8 тис.9 місяців тому
Default Conditional formatting is not enough to have such flexibility to control the color Properties in Power BI like Hue, Saturation, Lightness or Opacity. In This video, I will present you the way to control these color properties based on slicers. So that users will have the flexibility to setup the color's properties based on their requirements. Get Help into Questions Related to #powerbi,...
Status Indicator Slicer in Power BI | Can We Filter and Count with Status Icons?
Переглядів 5 тис.10 місяців тому
Status Indicator Slicer in Power BI | Can We Filter and Count with Status Icons?
Show Cumulative FORECAST and Actual on the Same Line | Power BI Line Chart Formatting
Переглядів 9 тис.10 місяців тому
Show Cumulative FORECAST and Actual on the Same Line | Power BI Line Chart Formatting
New Way of Creating Power BI Reports | DataFlow Gen 2 inside Microsoft Fabric
Переглядів 2,5 тис.11 місяців тому
New Way of Creating Power BI Reports | DataFlow Gen 2 inside Microsoft Fabric
DAX + ALGEBRA Fusion in Power BI | Create Tachometer Without Custom Visual or SVG in Power BI
Переглядів 2,2 тис.11 місяців тому
DAX ALGEBRA Fusion in Power BI | Create Tachometer Without Custom Visual or SVG in Power BI
Power BI Native Progress Bar | Create Progress Bars Without Custom Visual or SVG in Power BI
Переглядів 16 тис.11 місяців тому
Power BI Native Progress Bar | Create Progress Bars Without Custom Visual or SVG in Power BI
NO CUSTOM VISUAL | Create this Variance Chart in Power BI
Переглядів 7 тис.Рік тому
NO CUSTOM VISUAL | Create this Variance Chart in Power BI
Magic of Dynamic Data Label and Error Bars in Power BI | Create Next Level Line Charts in Power BI
Переглядів 3,4 тис.Рік тому
Magic of Dynamic Data Label and Error Bars in Power BI | Create Next Level Line Charts in Power BI
HIDE Power Query Transformation Steps from Power BI | Reusable M Codes with Expression. Evaluate
Переглядів 2,6 тис.Рік тому
HIDE Power Query Transformation Steps from Power BI | Reusable M Codes with Expression. Evaluate
Dataset Refresh Report with Power BI Rest API and Power Automate | Track all your refresh Status
Переглядів 18 тис.Рік тому
Dataset Refresh Report with Power BI Rest API and Power Automate | Track all your refresh Status
DAX Powered URL Parameter will Blow your Mind | Filter a Report from another Report in Power BI
Переглядів 3,5 тис.Рік тому
DAX Powered URL Parameter will Blow your Mind | Filter a Report from another Report in Power BI
Create ALL IN ONE Power BI Visual ✨| Show Previous Years, Forecast and YTD in a Single Visual
Переглядів 3,2 тис.Рік тому
Create ALL IN ONE Power BI Visual ✨| Show Previous Years, Forecast and YTD in a Single Visual
Default Current Month Name in Power BI Slicer | How to Show Latest Month Name Dynamically in Slicer
Переглядів 12 тис.Рік тому
Default Current Month Name in Power BI Slicer | How to Show Latest Month Name Dynamically in Slicer
Previous -N- Months or Future - N- Months with SELECTED Measures in Power BI |
Переглядів 9 тис.Рік тому
Previous -N- Months or Future - N- Months with SELECTED Measures in Power BI |
NEW Power BI Card Visual Will Blow Your Mind ✨ | Power BI June 2023 Update 👏
Переглядів 5 тис.Рік тому
NEW Power BI Card Visual Will Blow Your Mind ✨ | Power BI June 2023 Update 👏
Dynamically Remove Incomplete Week Dates from The Visual in Power BI✨
Переглядів 1,5 тис.Рік тому
Dynamically Remove Incomplete Week Dates from The Visual in Power BI✨
This is very interesting, thank you! I replicated it and it worked when testing it in PowerBI Desktop. However, in the PowerBI service the visuals still break. Do you experience the same and do you have a workaround?
Can we download the file somewhere?
To get the pbix file, you can send an email by mentioning the video title as email subject.
Some very interesting techniques
Thank you! Cheers!
guys your work is wonderful but please provide link to the power bi files. so we can experiment on our projects.
Glad to know it is helpful to you. to get the pbix file used in the demo, Please send an email by mentioning the video title as email subject.
It works like a charm!
Glad you like it.
Amazing! Thank you so much!
You're very welcome!
Amazing! Thank you!
Our pleasure!
Excellent! Thank you!
You are welcome!
Otro excelente video, otra forma es hacer la medida ranking con index+rank, saludos desde Chile el País mas largo del mundo con 4.200 km, gracias amigos
Gracias por ver.
Hello, will this solution work, if I have more than one store manager for same dataset??
Yes it will work. Additionally, you can also apply Row level security, if you wish to give role based access
@@PowerBIHelpline thank you so much, your solution is great.
wow just wow!!!
Cheers!
Thanks Bro
Welcome
Hi, how can I calculate the amount of rows which is visualized on the Sales table? Countrow is working only with dim_Date slicer, not with the Custom periods slicer. Thank you.
you need to use COUNTROWS() on virtual table created inside your measure using table function and filters.
@@PowerBIHelpline Thank you! With "Inside your measure"m do you mean in "period filter"?
Absolutely amazing. Just what I was looking for and couldn't find anywhere else. Thank you so much.
Glad it helped!
Finished watching
Thank you so much
I love you
is it for one selection only? what if for category i have option for select all or select multiple option?
You can even modify it for multi selection
Please explain the logic in last measure, I didn't get it. You are just trying to add results of two calculate functions instead of applying condition.
In the last example it shows that, if we use such conditions inside the iterator function like SUMX() over a large fact table, it will be slow. because it is going to validate over each row for those conditions. at the otherhand. calculate works on modified filter context. so it will first apply those filters, and then will calculate. which will be more efficient as compare to previous.
Due to duplication, sorting by sort order is not possible
This happens when you apply sort order on a column based on an order column which is created using the same column. We have posted a video about sort orders. please check it out.
Thank you! 3x ❤❤❤❤😊😊😊😊
Thank you so much
The period year column includes a string, so how does the comparison with the year integer from dimdate table
You can have another column for year in your dim date table with string datatype.
It’s a great video and it has helped me a lot! Just one question - can we make rank ignore null values in a column that is passed as a parameter? Currently I have an additional visual filter that uses sync with a condition that this visual filter is greater than 0, but it doesn’t work as expected with rank function you’ve described (it filters out the value and I get rank 1-9 instead of rank 1-10 as in condition😢)
i can use this when i need to show data for the last 4 period, but if i need to add data that only needed for current period it's pop up in every period do you have solution for that
This is a great topic, thanks for sharing!
You are so welcome!
My past is working fine but my future is pulling up everything on my rolling calendar how do I fix this problem
This solution shows for both past and future. please review and match your codes with the solution video
Hello, this is just what I was looking for and works perfectly on the matrix visual! I do get some issues when wanting to show this as a line chart and want to include both Month and Year on the X-axis. As soon as I toggle between calendar or fiscal, either the Year or the Month fall off the Line Chart's x-axis. Thoughts on how I can go about this?
is it possible to create like Total Sales as Background Transparent and front shows split by legend. Is it possible in Power BI? Excel we can Create
This is a good idea. We would like to post a video on this
Hi, GREAT VIDEO AND ABSOLUTLY WHAT i AM CURRENTLY LOOKING FOR NOW!! Problem after watching your video. The second option is not working for me. TIME LINE--2:35 When I tried changing the file name to zip file.. nothing happens. the file does not change to zip file like yours. Help!
No thanks 😂
Hi Can you please share this dataset. I have mailed you yesterday
My problem is that in my version of Power BI, the 'Data Colors' command is not available, so I don't know what alternative to use. Which version of Power BI has this command?
Use Latest version of PBI desktop. I think these features can be used from Feb 2024 version onward.
Awesome. Could you please make a video on how to use Rank to sort based on a list of values? Eg rankx -- The third argument of RANKX is useful when the outer -- evaluation requires a different expression than the -- inner one. For example, when ranking an expression over -- a pre-built lookup table DEFINE VAR SalesLevels = SELECTCOLUMNS ( { 6000000, 3000000, 1500000, 750000, 0 }, "@Limit", [Value] ) EVALUATE ADDCOLUMNS ( VALUES ( Product[Brand] ), "Sales Amount", [Sales Amount], "Level", RANKX ( SalesLevels, [@Limit], [Sales Amount] ) ) ORDER BY [Level] ASC 2. How to do approximate match lookup in powerbi
Very creative, but DAX and audio explanations are too fast to grab and understand. I have to rewind several times to get the concept. Anyway, great video.
Great suggestion! Thanks for providing your valuable input.
can you share the dax code here?
DAX Code- VAR _baselink = "app.powerbi.com/groups/EnterGroupID/reports/ReportID" VAR _filter = "?filter=Dim_Date/Year-Month in ('" VAR _Filteryearmonth = CONCATENATEX( FILTERS(Dim_Date[Year-Month]), Dim_Date[Year-Month], "','" ) & "')" VAR _brandfilter = " and Product/Brand in ('" & CONCATENATEX( FILTERS('Product'[Brand]), 'Product'[Brand], "','") & "')" RETURN _baselink & _filter & _Filteryearmonth & _brandfilter
Thank You for the solution video , I have also mailed for this query, But in my scenario only one year is showing, Please tell what to do ?plz reply
We have posted few more videos about dynamic column headers, please check it out. Meanwhile we will look into your query.
Very useful information
Glad you liked it
Thanks for your video! But I have 1 question: If I have a lot of report in my workspace and I want to monitor all historical status of them, how can I do it? Because I see we input the group_id and dataset_id, with 1 report just has 1 dataset_id
There are REST APIs already available for such usecases. you may need to use more than 1 API step by step. Please checkout Microsoft official documentation about Power BI Rest APIs
Amazing! really helpful!
You’re welcome 😊
I tried this approach but it didn’t work .please help me
Make sure you are not missing any point. you can send an email to get the PBIX file used in the demo to compare if anything is missing.
😮 Thank you 🙏
You’re welcome 😊
Hi .i am getting error...it says the sort can't be done as there are multiple values associated.can u pls help
sort order need to be created for unique values. you may need to concatenate with some other column to make it unique. e.g. Year*100 + month this may result like 202405. and this year_month is unique even if you have many years.
does this also work on a stacked bar chart?
Thanks for watching. There are some new features for bar/column charts, which could be used for such requirements. we have posted a video demonstrating those features. Please check it out.
So stupid that something as simple as this and show N periods in a visual isn’t just an option.
Thanks for the video. Similar to how there is the “forecast” extension to the actuals, it would also be nice to see trend (sounds similar to forecast but in my world, the trend is different. Forecast is human input and can always be much higher). Also an extension or a whole different line for budget. And a way to evaluate the forecast vs budget by + or - 1,2,4 percent
Great suggestion! Thanks for providing your valuable input.
So I have a power bi report user. If this report user clicks refresh, would it be possible to trigger the API to put updated data down to the report?
For that you can add a Power automate Button on your report which is configured to refresh the published report once clicked
It isn't streaming dataset it is simple dataflow.
In this example, Streaming dataset is created in power bi service which sources the refresh history of a simple dataflow.
@@PowerBIHelpline Can you solve my problem? Every 5 minutes I want to stream data to a streaming dataset containing 3 pieces of 15-minute data. Unfortunately, I don't have any new data in 5 minutes, only the existing ones are updated. The real time dashboard is updated only when there is new time data. And it doesn't update retroactively if you don't. How do I manage data refresh every 5 minutes to a streaming dataset if I don't have any new data? The company's workspace update data limit is 15 minutes. I generate the data in Python and only 1 normal SQL Available.
Thank you for your help! I have 1 question: when I got to the very end to check, my month is sorted alphabetically instead of Jan Feb Mar etc. do you know how to fix this?
there are many ways to sort the month names, The easiest way is- sort the month name by month number
I was trying to create a similar logic but it did not work, compared to you I did it a filter for the past one year, like if I select this year from a slicer, it was supposed to show previous year : New OPEN requisition = VAR _fromdate= IF ( Selectedvalue('Past/Future'[Past or Future])="Past", MAX(NEWDATET[Year]), Min(NEWDATET[Year]) ) VAR _pastfuturemonthshift= SELECTEDVALUE('Past/Future'[Multiplier])*MAX('No. of year'[No. of year]) VAR _periodshift= DATESINPERIOD(NEWDATET[Year], _fromdate,_pastfuturemonthshift, YEAR) Return Calculate( [Open Requisition], REMOVEFILTERS(LU_Calendar), KEEPFILTERS(_periodshift), USERELATIONSHIP(LU_Calendar[DateValue_DATE], NEWDATET[DateValue_DATE]) )
Super! Thanks!
Welcome!
Sir I have tried Measure formula as I have seen but it doesn't show the sum of the selected column in visualization in Graphical way. It says that Couldn't load data for this visual because MDX model script (3, 36) calculation error in measure. What can I do? Please reply
Please check the datatype of fields used in your DAX expression. it seems you may have incorrect datatype for any particular field used.
@@PowerBIHelpline I am talking about measure sum formula. It is not showing in graph.