PowerBI RB, Data not outputting when Running
Good Morning all! I am creating an order acknowledgement for a company and have experienced an issue. I have created a table (the ones with a black box around them) successfully conecting to my datasource, pulling values named Ship2_address1, Ship2_address2, Ship2_name, Ship2_postcode and Ship2_city, as well as Bill2 for the same fields. I have also created a parameter to only output data relative to another field i've referrenced in another table (the one at the bottom of the page). However, when I try to run this document I do not get any data loading for my top two tables, but I do for my bottom one. To my knowledge I have configured them the same way I have as the bottom one. So far, I have tried reconnecting and testing my data source to ensure its correct (which it is), I have remade the table to ensure that the data fields are correct (the fields are correct) and I have removed and re-added the parameter to see if data can be brought out... I also do not have much experience with PowerBI as a whole so I may have just made a small minor mistake on this. If any clarification is needed on this matter please let me know Kind regards and looking forward to any replies, Avery
How to show latest date as default selection in a slicer.
Hi Team, Please help me out with this query. How to show latest date as default selection in a slicer. For Example, we have a date column contains date from 01-10-2022 to 22-12-2023. So, when i drag to slicer i need to show defalut selection as 22-12-2023. If user need to select other date he need select. otherwise it should be default. Thanks & Regards, Prasad
Needing help Create custom parallel interactive bar chart
I need help with creating the middle chart The dashboard looks like butterfly chart for hires and exits, with a parallel bar chart in the middle showing headcount and promotions for each headcount grade level -as Power BI lacks this visual I am trying to do it with python but I am unable to find the right code to generate the middle graph and make it interactive with the bar charts on the left and right. ** so the requirement is creating three subplots: left for hires for each career level, middle for headcount/promotions for each career level *up of each other* in parallel and showing the (number, percentage ), and right for exits, all sharing the same y-axis (career levels).
WPA Expiry Analysis getting MAX Function Error
For this employee, whose WPA expires on 09-08-2024, I need to search in columns WPA 1, WPA 3, WPA 4 (with a role filter for Floor Leader), WPA 5, WPA 9, WPA 10, WPA 11, WPA 12, WPA 14, and WPA 15 to retrieve the latest date and compare it with the WPA expiry date. If the date is before the WPA expiry date, it's marked as expired. If it's within 30 days of expiry, it's labeled as expiring soon. Only the entries in WPA 4 column corresponding to the Floor Leader role are considered. I'll implement this using DAX Example Data : Employee Role WP1 WP2 WP3 WP4 WP5 WP6 WPAEXPIRY Adam TERMINAL 05-12-23 10-08-23 22-08-23 10-08-23 10-08-23 09-08-24 FLOOR 10-08-23 I Have created dax for VAR LatestExpirationDate = MAXX ( VALUES ( 'All'[Employee Name] ), MAXX ( ROW ( "WPA1 Latest Date", 'All'[WPA1 Latest Date], "WPA2 Latest Date", 'All'[WPA2 Latest Date], "WPA3 Latest Date", 'All'[WPA3 Latest Date], "WPA4 Latest Date", 'All'[WPA4 Latest Date- for Terminal], "WPA5 Latest Date", 'All'[WPA5 Latest Date], "WPA9 Latest Date", 'All'[WPA9 Latest Date], "WPA10 Latest Date", 'All'[WPA10 Latest Date], "WPA11 Latest Date", 'All'[WPA11 Latest Date], "WPA12 Latest Date", 'All'[WPA12 Latest Date], "WPA14 Latest Date", 'All'[WPA14 Latest Date], "WPA15 Latest Date", 'All'[WPA15 Latest Date] ), MAX ( 'All'[WPA1 Latest Date], 'All'[WPA2 Latest Date], 'All'[WPA3 Latest Date], 'All'[WPA4 Latest Date- for Terminal], 'All'[WPA5 Latest Date], 'All'[WPA9 Latest Date], 'All'[WPA10 Latest Date], 'All'[WPA11 Latest Date], 'All'[WPA12 Latest Date], 'All'[WPA14 Latest Date], 'All'[WPA15 Latest Date] ) ) ) RETURN IF ( LatestExpirationDate < MAXX(VALUES('All'[Employee Name]), MAX('All'[WPA EXPIRY])), IF ( DATEDIFF ( LatestExpirationDate, MAXX(VALUES('All'[Employee Name]), MAX('All'[WPA EXPIRY])), DAY ) <= 30, "Expires Soon", "Expired" ), "Not Expired" ) but i am getting Error Too many arguments were passed to the MAX function. The maximum argument count for the function is 2. Looking for support thanks in advance 😊
Working with NA data
Hi, I'm still learning and did some research into the topic. It looks like Power BI doesn't have an ifna function like excel and uses lookupvalue. I looked at those threads, but couldn't figure out how to apply it to my situation. I'm working with City data that has a quadrant system (NW, SW, NE, and SE). The source has two sets of quadrant data. Normally I would assume they are the same and choose one, but life is just never that easy. Note, this is a sample and not indicative of how many N/A's are in each column. Priority I'm assuming I will need to add a new column, but I don't know how to write the formula. It would compare "quadrant" and "geo_area_quadrant". If the two are equal, then it doesn't matter which column it pulls from. If either is N/A, choose the column with data that isn't N/A. Add on option A (if possible) I'm not sure if this is possible, well an easy way for the following ask... this is an issue with the raw data. In the instances where both columns are N/A, is it possible to extract data from an address column? If so, could it be combined with the column in my priority ask above, or would it be an additional column? Thanks in advance!Achieving Filtering in Dynamic Power BI Matrix
I'm working with a dynamic matrix in Power BI, where the rows can change based on one field parameter (e.g., from audience to brand), and the values can change based on another field parameter (e.g., from bounces to clicks). The columns represent different weeks. My goal is to filter the matrix to display only rows where the total across all weeks is greater than zero. However, when I select a different field (e.g., changing from bounces to clicks), the filter also changes to match the selected metric. I want the filter to remain consistent and filter out all rows where the column total is zero, regardless of the selected metric. How can I achieve this?Not able to display icons as labels.
I was trying, using the custom label functionality, to display an icon indicating a top-ranked supervisor but, no matter what I try, it always displays the character code rather than the icon itself The odd thing is when I try to do basically the same thing on the Power BI Desktop it works just fine Any thoughts on this? Thank you all.
