Problem 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.Average versus average based on filter
I need to use the result of a visual matrix to calculate a new column. The data below is a simplified version of the data I have. Table A Fuel Type Gallons Gross Cost Diesel Regular 126.76 417.04 Diesel Premium 305.00 1,238.30 Unleaded Regular 508.00 1,452.88 Unleaded Premium 653.00 2,148.37 Diesel Regular 350.00 1,106.00 Diesel Premium 250.00 972.50 Unleaded Regular 268.00 828.12 Unleaded Premium 186.00 717.96 Table B Fuel Type Preferred Fuel Type Diesel Regular Diesel Regular Diesel Premium Diesel Regular Unleaded Regular Unleaded Regular Unleaded Premium Unleaded Regular First desired result is: Fuel Type Sum of Gallons Sum of Gross Cost Avg Cost/Gal Diesel Premium 555 2210.8 3.98 Diesel Regular 476.76 1523.0404 3.19 Unleaded Premium 839 2866.33 3.42 Unleaded Regular 776 2281 2.94 Total 2646.76 8881.1704 3.36 I want it to take the average cost per gallon determined from this visual and add a column that shows what the cost would be if they had purchased the preferred fuel type. Final Desired Result Fuel Type Sum of Gallons Sum of Gross Cost Avg Cost/Gal Cost w/Pref Fuel Diesel Premium 555 2210.8 3.98 1,772.98 Diesel Regular 476.76 1523.0404 3.19 1523.04 Unleaded Premium 839 2866.33 3.42 2,466.18 Unleaded Regular 776 2281 2.94 2281.00 Total 2646.76 8881.1704 3.36 8,043.21 I have tried multiple ways and am not getting it to work. Basically need to show them what it would cost if they didn't purchase the premium fuel.
Navigation + Filtering in a custom Deneb Vega visual
Dear reader, I'm a consultant currently working on a Power BI dashboard which has required me to include a custom visualization. For this I used a Gantt Chart template created by David Bacci (see Deneb-Showcase/Gantt Chart at main · PBI-David/Deneb-Showcase · GitHub for the code) The standard template looks as follows: The client is asking me to implement a feature that allows users to select a value in the "Tasks" column, e.g. "Story boarding", and navigate to another page with a tailored view based on this selection. So, for example, one would click on "Story boarding" in the column and the dashboard will then navigate to another tab. And in this tab the visuals will be filtered such that "Task == Story boarding". I have discussed within my team that this is likely impossible, but we wanted to know for sure. An alternative solution is of course also welcome! Unfortunately, an invisible button overlay will not work, because in our case there will be a lot of rows and scrolling will be required. Besides, the visual will be dynamically updated. Thanks a lot in advance! 🙂
TABLE 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 2How do I group columns by category in the same pivot table in excel?
Good afternoon guys, what's up? I need some help I'd like to layout the PowerBi "Matrix" in the same way that the "Pivot Table" groups the categories before showing the value, as shown in the photos below. 1. Excel - Pivot Table In the image below we can see that the pivot table first categorizes the values - Volume/Weight and Volume Measure - before grouping by BAT/PMI and JTI 2 - Power BI - Matrix In Power BI, the "Matrix" does just the opposite, first it categorizes BAT/PMI/JTI and then it categorizes the values I would like to know if it is possible to visualize the "Pivot Table" (example of photo 1) in PowerBI with "Matrix"?Matrix with flags
Hi everyone, I have 3 datasets: Product, Client, Transactions and Calendar (Some Date - today()) as follows I need to compute the monthly count of transactions for each product starting over the last 15 months. The goal is to be able to flag products with no transactions over the last 15 months (red flag), products with no transactions over the last 12 months but there were some transactions over M-12, M-13, M-14 (orange flag) and products with at least one transaction over the last 12 months (green flag). Here is the sought-for output: product_id || product_name || M || M-1 || M-2 || ... ||M-12 || M-13 || M-14 || Total || Flag 1 Books 1 1 0 ... 0 0 0 2 green 2 Pens 0 0 0 ... 0 1 0 1 orange 3 Pencils 0 0 0 ... 0 0 0 0 red Total 1 1 0 ... 0 1 0 3 Here is the Model I succeeded (with the help of the community) to find the measure computing monthly total of transactions by product, the problem is that the matrix visual doesn't allow to get the output mentioned before where I can add a measure Flag to classifiy products . Another question, is it a good idea to relate the calendar table to any of the main tables ? because I want to filter many dates in the different tables using that date table. Any idea is appreciated ! Thank you 🙂SSO/Authentication for Custom Visuals
Hi All, can you please advise on how to perform Single Sing On (SSO) for users who are going to consume data using a Custom Visual? I need to get the user's session token in order to trigger some backend processes using the Custom Visual. Your help is appreciated. Thanks.
