10 ай бұрын
Пікірлер
@twkyoscr 16 сағат бұрын
I understand the measure created but not sure how to link period slicer table with no relationship to my date table. Please provide more detail, this is not specified
@nitinmathur7069 7 күн бұрын
very good workaround, just observed you can't sort the Final measure though
@stevanmomcilovic4469 13 күн бұрын
I have created an app, but can't edit the data and don't have a plus button in right upper corner, why?
@ThomasVanBuynder 14 күн бұрын
I am trying to connect my bar chart with a slicer, although it does not seem to work. I would like to get the selected company in the slicer to be highlighted in the bar chart, although it either highlights all companies, or it only showcases the selected company, without showing the other companies. Any idea how I can solve this?
@emmanuelaolaiya 15 күн бұрын
Thanks so much
@PowerBIHelpline 13 күн бұрын
You're most welcome!
@rafaelosipov3820 18 күн бұрын
Great Solution! Just Brilliant. How can I change the order of the columns in my matrix of the KPI column?
@damionc 18 күн бұрын
What if I want the forecast to be split by product as well?
@mruniversemrwhite333 19 күн бұрын
its not working for me. did exactly as you said.When i dont choose any values in the slicer It is showing as expected for last 6 months.But when i choose a period from the slicer it is showing only that month instead of showing the last 6 months from the selection.Pls help
@Meme_verse1 20 күн бұрын
How to track the refresh history for all the datasets in a workspace instead of just one dataset that you did.
@PowerBIHelpline 20 күн бұрын
For that you need use 2 APIs. the first one is to get the datasets from a workspace, and then using it as parameter, you need to run the 2nd API to get the refresh histories in a loop for all the datasets. API to get dataset in a workspace is available at the same page which is shown in the video.
@Meme_verse1 18 күн бұрын
Thank you so much for such a quick response, I will check that.
@sadiqabkr 21 күн бұрын
Beautiful and automatic. Thanks 👍
@PowerBIHelpline 21 күн бұрын
Thanks, I'm glad you found it useful!
@Nalaka-Wanniarachchi 22 күн бұрын
Cool.Really very helpful....
@PowerBIHelpline 22 күн бұрын
Awesome! Glad it helped.
@AfshinRashvand-i3j 22 күн бұрын
Is it necessary to create a new date column?
@PowerBIHelpline 21 күн бұрын
For this requirement- Yes!
@RelaxNoise24 26 күн бұрын
is it possible to achieve this with excel or sharepoint list instead of MSSQLS?
@PowerBIHelpline 23 күн бұрын
Automatic page refresh is available with direct query connections only. however you can use any other source, but your numbers will be reflected with next refresh of your dataset.
@pranithaambadapudi5405 Ай бұрын
Can we achieve this through Power BI - free licence type.
@PowerBIHelpline 29 күн бұрын
You can not share reports with others with free license.
@maimounadiop1056 Ай бұрын
Thank you so much
@PowerBIHelpline 29 күн бұрын
You're most welcome
@vkripz Ай бұрын
is there away to display actual date Values?
@PowerBIHelpline Ай бұрын
Yes it can be displayed same way as we did with month names. your dates will show as it is. and it will be formatted as text.
@sahilbirje1339 Ай бұрын
When no month is selected it shows for last two months in the data... But when a month is selected only that specific months data is shown... Need Help
@PowerBIHelpline Ай бұрын
Yes, this is possible with small modification to the same DAX
@TrassBI Ай бұрын
Very useful ✨ Thanks for sharing!🚀
@PowerBIHelpline Ай бұрын
Glad it was helpful!
@rickosupriyanto1990 Ай бұрын
Can we use 2 email on the same row & column? The power BI still auto sent to both email or need a different Dax to sent it?
@PowerBIHelpline Ай бұрын
You need to add it the next row
@mirrrvelll5164 Ай бұрын
Wow what a great video. Can you also add all kinds of user infos there, like, numbers, date, strings? And will it be accepted into the DB?
@PowerBIHelpline Ай бұрын
Yes definitely. you can define the data types. Thanks for watching.
@akusins Ай бұрын
Power App license should have all users who wants use commenting option ?
@PowerBIHelpline Ай бұрын
Yes. and you also need to share your app with those users from power app website.
@arghyadutta9091 Ай бұрын
Great
@PowerBIHelpline Ай бұрын
Thank you !
@Michael-sg7nf Ай бұрын
After trying all day, finally this method works. Thanks!
@PowerBIHelpline Ай бұрын
Glad it helped
@drudd75077 Ай бұрын
How can I change the order of the columns displayed?
@Safar_With_Madhu Ай бұрын
Hi may I know rather than workflow id if we can provide name like dev, test and prod and the backend it will take workflow id only...as if multiple id its bit confusing workflow id is?
@PowerBIHelpline Ай бұрын
Yes, you can do that, you just need to add one additional step in power query to map the Workspace's Ids with its names
@govindsajeev8754 Ай бұрын
How can I do the conditional formatting to give green color alone for the month with highest no of sales?
@PowerBIHelpline Ай бұрын
Thanks for watching. We have posted videos about conditional highlights including the highest/lowest values please checkout the playlist.
@mithrasaravanan4843 Ай бұрын
How can I select the top 5 values from a clustered column chart and display those values in a new table in Power BI?
@PowerBIHelpline Ай бұрын
Thanks for watching. We have posted a video about showing top 5 values and "others in a Matrix visual. Please check it out. That will automatically select dynamic Top 5 items based on your interactions in other visuals as well. Please checkout the Playlist.
@shravanthipabba8122 Ай бұрын
How did you create access table?
@PowerBIHelpline Ай бұрын
You may want different combination of column filters for different people accessing the data, and this need to be maintained based on what level of security you want to apply
@shravanthipabba8122 Ай бұрын
can you please tell me in detail how access table is created?
@sanj3189 Ай бұрын
I am not finding some of the options in my power bi is this premium or pro version
@PowerBIHelpline Ай бұрын
You should update the Power BI desktop to the latest version and from options and settings ->preview features -> Check if relevant feature is enable or not. Power BI desktop is a free application. Those licenses comes into picture when you publish it the workspaces.
@PrashantGeminiMaheshwari 2 ай бұрын
could you please share the dax measure or template you have used in this video
@PowerBIHelpline Ай бұрын
To get the PBIX file used in the demo, you can send an email my mentioning the video title as email subject.
@elfridhasman4181 2 ай бұрын
Thank youu
@PowerBIHelpline Ай бұрын
You're welcome!
@kimwullems 2 ай бұрын
Can you also have two lines in one graph; one ytd growth and one monthly sales? Awesome video!❤
@PowerBIHelpline Ай бұрын
Yes you can!
@TheRealRSProductions 2 ай бұрын
Any way to make the markers below actually appear in line with the end of the bar? Sry, but this just looks sloppy.
@PowerBIHelpline Ай бұрын
Yes you can definitely do that. It's just about adding little more offset to that pointer value. you need to try with few values to find out the optimum value on which it seems fit to the mark you want it to be placed.
@msathishwhite6431 2 ай бұрын
Hi sir, I have 12 level of category in the row fields of matrix table, if I expand from top level to lower of cate oh category, each category row oh header showbe highlight with different colour, how to achieve it
@PavanCh-q2u 2 ай бұрын
Thanks for the great content...much appreciated. I need one help very badly, scratching my head, but no success. I have a use case where I am getting data from matrix visual in Power BI report. I want the functionality once the button clicked (Power Automate in Power BI) and I want dynamic data which is showing in my matrix visual in Power BI to be exported to excel (the number of dimension/categorical fields are dynamic based on "Field parameters (which are dimensions not measures)" like sometimes the user will select 4 or sometimes 5 but max 8 and numeric or measure fields are static and there are around 10. Here is the main thing, the data should be exported to "Excel" in a hierarchical fashion (Parent and Child), should be like: Name Value1 Value2 Parent 100 200 Child1 100 200 Child2-1 50 100 Child2-2 50 100 Is it possible using Power Automate. Any suggestions or help are greatly appreciated. Thanks in advance.
@mnowako 2 ай бұрын
This is magic and you are the Magician :) Thank you!
@PowerBIHelpline Ай бұрын
Wow, thank you!
@mnowako 2 ай бұрын
This is magic :)
@PowerBIHelpline Ай бұрын
Thank you so much
@thrijith5317 2 ай бұрын
Not able to select get on data my power bi app gets hang and stuck
@PedroHenrique-bp8ts 2 ай бұрын
Thank you very much, man
@PowerBIHelpline Ай бұрын
You're welcome!
@allaboutdata4634 2 ай бұрын
Thanks for the solution. Can we highlight background of table cell according to slicer selection
@PowerBIHelpline 2 ай бұрын
Yes, you can
@jelledaems808 2 ай бұрын
thank you for this video. I learned a lot from it. However, this solution only tracks the history of 1 dataset. I have more than 2000 datasets. Ideally I would like to see the history of all of them in one report.
@PowerBIHelpline Ай бұрын
This is just the way to get into those space. and There are Power BI APIs available which combinations can read all the datasets from the workspace and then wrangle through it to get the refresh history for all by passing the parameters as the collected dataset Ids in loop.
@jyothinadiya8353 2 ай бұрын
Wow, its very helpful for my requirement. Thanks 👍
@PowerBIHelpline 2 ай бұрын
Glad it was helpful!
@ceceDjane 2 ай бұрын
This video save my life Thank you
@PowerBIHelpline 2 ай бұрын
Glad it was helpful!
@eddyngonzalez2761 2 ай бұрын
It seems this approach doesnt work with a file saved on the web such as a notepad in google drive or onedrive
@AITrendsExpert-in9qj 2 ай бұрын
how can you also include a category slicer to this?
@PowerBIHelpline 2 ай бұрын
Yes you can
@naimuddinsiddiqui9249 2 ай бұрын
I really appreciate your Innovatve way of implementation using Popup with Rls. Only thing I would ask have you tested same file by publishing to Power BI Service ,Is it working properly because I too tried same approach unfortunetly RLS is not working as per Expectation.
@PowerBIHelpline 2 ай бұрын
Yes it works. please check if your users are not already members or Admins in your workspace.
@MpT_Head 2 ай бұрын
As @workstuff5253 below said, given a few small language errors and the use of an AI narrator (which is clear to understand), this is a really useful video showing how to handle incomplete data. As useful as Field Parameters are, I am always looking for alternatives. They are very convenient for fairly straightforward scenarios but don't work well for all cases. Well done.
@PavanCh-q2u 2 ай бұрын
Very helpful...I have a similar use case.... I have a matrix visual with 6 to 7 levels, but the hyperlink enable from level 4 i.e SubCategory till level 7 dynamically.... 1. Level 1 - Ship Mode 2. Level 2 - Region 3. Level 3 - Category 4. Level 4 - SubCategory 5. Level 5 - Product 6. Level 6 - Supplier 7. Level 7 - State Here how it should work...as I mentioned the hyperlink should enable on the metric/measure from level 4 - SubCategory in which hyperlink should pass all the values of current level as well as previous levels (SubCategory, Category, Region and Ship Mode) Next level i.e Product in which hyperlink should pass all the values of current level i.e Product as well as previous levels (SubCategory, Category, Region and Ship Mode) so on.....I tried with HASONEVALUE, but it's not working as expected..... Could you please make video on the same ASAP as I have some requirement...it will be a great help and hope it will help others... Thanks in advance....
@shantiprasadkulkarni3314 2 ай бұрын
Its not working for dynamic x axis
@PowerBIHelpline 2 ай бұрын
It Depends upon how you are defining the dynamic axis. all axis which are part of your field parameter should come from the custom table's columns
@stanTrX 2 ай бұрын
If it is in excel, why not just copy paste the data only and break the links and delete the power queries
@PowerBIHelpline 2 ай бұрын
That can be done for limited data in excel , because In power BI enter data, you can only copy paste upto 3000. Also the real question here is to hide your transformation steps which you don't want to show to any other and not the data source.