@power bi
9 TopicsProblem with My Custom Visual in Power BI
I've developed a DatePicker visual for Power BI, but I'm facing an annoying issue that affects user experience. When users interact with the report, my visual keeps flickering between showing the selected date and showing "Select period" (the no-filter state). This rapid alternation between states happens most noticeably when users select a date or click the "Clear filters" button in Power BI. The root cause seems to be that my visual receives multiple contradictory updates from Power BI in quick succession. One update tells the visual that filters are applied, then immediately another update says no filters exist, then back again to filters being applied. This creates the flickering effect as my visual tries to respond to each update. I'd like to know if this behavior is normal in Power BI or if there's a recommended way to handle these contradictory updates. Is there a technique to make my visual display a consistent state? Also, is there a reliable way to detect when a user has clicked the "Clear filters" button? Any help or suggestions from those who have encountered similar issues would be greatly appreciated.Question about Prior Month Measure against custom measure using distinctcount
I have a measure I created: Total Staff = var _table=SUMMARIZE('All_NICE_Data','All_NICE_Data'[Agent Name],'Calendar Dates'[Date],"distinctcount",DISTINCTCOUNT('All_NICE_Data'[Agent Name])) return SUMX(_table,[distinctcount]) This validates perfectly. Now I need to create a calculation to get the prior month calculations. Normally I would use: Previous Month Staff = CALCULATE( SUM('All_NICE_Data'[Total Staff]) , DATEADD( 'Calendar Dates'[Date], -1, MONTH ) ) This is not working. How do I calculate the Previous month against the Total Staff measure?Solved1KViews0likes1CommentTABLE VISUAL - NOT SHOWING CORRECT VALUE
Hello Everyone, I'm a newbiew working on a BI report, I want to show/display the header (Questions) as rows. Then categorize it now by 2 columns which is Manufacturer Rate & Supplier Rate. The concern is I use a filter to sort/display the result below by using the respondent category and supplier name. If this question was raise before and resolved please help me redirect to that same question. Appriciate any support provided. Sample I will use the following filter; Respondent = Manufacturer, Supplier = ABC Enterprise. The expected output should be like, on Question | Manufacturer Rate | Supplier Rate PPM's L12M | 6 | 7 Data Source Below: Respondent Category PPMs L12M: PPMs L12M Remarks: PPMs L3M: PPMs L3M Remarks: Sub-Tier Supplier Management: Sub-Tier Supplier Management Remarks: Manufacturer 6 TEST ONLY 9 TEST ONLY 1 TEST ONLY Supplier 7 TEST ONLY 7 TEST ONLY 2 TEST ONLY EXPECTED OUPUT: Questions: Manufacturer Rate Supplier Rate PPMs L12M 6 7 PPMs L3M 9 7 Sub Tier 7 2Solved1.8KViews0likes4CommentsBest Type of chart to represent avg, below avg, and above avg
Hi folks! I'm asked to prepare a chart that represent the average score for groups of people and show as well how many of them scored above average and how many scores below average. What's the best way to represent these info without looking messy and complicated for the end user? note that i have +4 groupsIndustry Slicer - Blank is appearing
Hi, We have cleaned the industry field and there are few blank fields, so replaced null = No Information Kindly check the attached image as well. When I add the Industry Table in slicer. Ideally, it shouldn't display (Blank), but for some reason I can see both (Blank) and No Information Field in the slicer. I've added a card to show the value of slicer. When I select (Blank), it's showing number. (Count of Blank fields in the table) When I select "No Information" field, it's showing zero. As you can see in the Industry Table, I can clearly see "No Information" Field Highlighted in yellow and within red box. Can somebody help me to understand what's the problem here ? How to solve this issue ? Your inputs are much valuable to me. Thanks in Advance. Best Regards Raja Sahir_Maharaj443Views0likes0CommentsPie chart with below 1M values need to visual with exact number like (10k, 150k, or any number?
Hi Team, Good Morning! Currently my total values in pie chart are like 1M, 1M, 0M and 0M. So as per requirement 1M i need to leave it as it is and 0M need to change it as like 10k, 15, or 100(any number) etc. Kindly please help on this case. please suggest with snapshot more helpful.2KViews0likes6CommentsSlicer of filter values are with data type (i.e) whole integer, But not getting search option?
Hi Team, Good Morning! Currently in my slicer of filter values are with data type i.e whole interger. and the values are shown with 12 digit number like below snapshot. Can you please suggest, If data type change it to text then we will get serach option, but it is not correct way. Please suggest how to fix this issue(suggest with snapshots please) or any DAX or any other way. Kindly help me to fix this issue. Thanks in Advance.Solved1.1KViews0likes2CommentsKindly help me for conditional checkbox with action required on dropdown filter of below snapshot.
Case 1 : Filter beside below highlighted snapshot of red color highlighted check box how we will place? Case 2: And If you check the checkbox and select the dropdown, then it should show all the list of names. Case 3: If you uncheck the checkbox and select the dropdown, then it should show all the list of names. Kindly can you please suggest and do needfull for above cases!849Views0likes3CommentsKindly help me for conditional checkbox with action required on dropdown?
Case 1 - Filter beside snapshot of red color highlighted check box how we will place? case 2-  And if you check the checkbox and select the drop down, then it should show all the list of names. Case 3- If you uncheck the checkbox and select the drop down,then it should show all the list of names. Kindly can you please suggest and do the needful for above cases.