Power BI – How to Reset Slicer to Default Value Based on Another Slicer Selection?
Hi Community, I have a Currency slicer (INR / USD) and a Display Amount slicer with values: ONES THOUSANDS LAKHS CRORES MILLIONS BILLIONS Requirement When INR is selected → Display Amount slicer should show ONES, THOUSANDS, LAKHS, CRORES When USD is selected → Display Amount slicer should show ONES, THOUSANDS, MILLIONS, BILLIONS THOUSANDS should be the default selection for both INR and USD When switching from USD → INR (or vice versa), the Display Amount slicer should reset back to THOUSANDS automatically, instead of keeping the previously selected value (like MILLIONS). What I’ve Tried Created a DAX measure returning 1 / 0 to filter Display Amount values Applied the measure as a visual-level filter The visibility works correctly, but Power BI does not reset the slicer selection to THOUSANDS when the Currency slicer changes Any best practices or workarounds (bookmarks, disconnected tables, etc.) would be greatly appreciated. Thanks in advance! 🙏 Fig 1: Fig 2:
Visualisation (Slicer and Button Slicer)
Hi everyone, I hope you all have a nice day. I want to ask (pictures attached), I gave an example of me using visualisation of "Button Slicer (Top)" and "Slicer (Bottom)" in the picture, I have a table where I have Reporting Date column then I make custom column for the quarters and months. The "Year" in the slicer is from Reporting Date hieararchy (Year), but the quarter and month in the slicer, they both are custom column that I made from the Reporting Date column (so they are not the hieararchy of "Reporting Date"). My questions (I don't mind if you answer with "Slicer" visualisation or "Button Slicer" visualisation): In Picture 1, If I select Q1 and it turns grey, how do the visualisation slicer for months turns black (for Jan, Feb, Mar) without me selecting the Quarter slicer? In Picture 2, If I select any month (for example: Aug) and it turns black, how do the visualisation slicer for quarter turns grey (Q2) without me selecting the Quarter slicer? In Picture 3, If I select Year "2025" and it turns black, how do the visualisation slicer for quarter and months also turns black without me selecting Quarter and Month slicer? Please kindly help me answer my questions. Thank you in advance. God bless. 😊🙏
Gantt Chart Visualization Offered by MS Power BI (no Charge)
Hi, It seems like the Gantt Chart provided by MS doesn't allow vertical Grid Lines nor the adjustment to the actual leftmost label, such as below. Is there a way to show the entire Task and not an abbreviation? Please see the below snapshot showing as an example of the two items for GRID now showing and the Task Title is abbreviated. Thank you
Custom Visual
I am wanting to create a visual for cartons going into a trailer based off the cubic inches I know exist in the trailer and the cubic inches I know of each carton coming into the trailer. I have all my data set and ready but I can not figure out how to setup a fill for the selected trailer area in BI?
Power BI Custom Visual
Hi, I'm interested in learning whether it's possible to create the visual depicted below in Power BI. Each bubble represents a project's status at a specific stage. When a particular stage, such as 'Survey,' is clicked, I'd like it to expand and display the status of the sub-stages within that stage. Could you kindly inform me if this can be accomplished using either existing Power BI visuals or by utilizing a custom visual? Do i need experience with D3.js necessary to achieve this? I would greatly appreciate any assistance with this matter. Thank you!Shared contents is called each time loading a table in Power BI Custom Connector
We're developing a Power BI custom connector in Visual Studio 2019 using Power Query SDK. While the inputs are first authenticated based on our logic, then it goes to the Navigation table. Here in this section for loading each table from the available list entire PQ file is called((i.e. authentication, querying) which is not optimized and best solution for the use case. We suspect it could be due to the shared.Content is called every time. However, we are unsure about this issue's solution or root cause. Please suggest a solution to move forward by resolving this. Also, there are no related documents on web as per our search.
Microsoft Power BI - Need to trim the line in the graph for Actual income (Current Financial Year)
Dear Mates, I would like to create the actual line in the graph2 which is similar to graph1. Graph1 shows the actaul line as i expected until current month of the Financial year. As we can see the graph2 The actual shows the line until 2024 March. I would like to restrict that line to show untill current month of the finacial year and want to make it dynamic similar to graph2 Graph :1 ( Correct or expected) Graph :2 (Need to Trim/Change) The Dax measure which i used for calculating Cumulative income for the Graph:2, I mentioned in below. We need to do filter in the month for limiting curve to show the line until current month of the FY. I'm strugguling to do this, please help me to do solve this issue. actual_income_cummulative = CALCULATE( SUM('analytics commercial_opportunities_graphs_view'[actual_income]), FILTER( CALCULATETABLE( SUMMARIZE( 'Date Opportunity', 'Date Opportunity'[Date Order], 'Date Opportunity'[Date 2] ), ALLSELECTED('Date Opportunity') ), ISONORAFTER( 'Date Opportunity'[Date Order], MAX('Date Opportunity'[Date Order]), DESC, 'Date Opportunity'[Date 2], MAX('Date Opportunity'[Date 2]), DESC ) ) ) Note: the above calculation is done using quick measures. Which is already available in power bi. Thanks in advance.How to retain the value of configuration in custom visual?
I have implemented the custom visual with configuration called :Unique Dates Per Page, when i set some value, its taking up the value but when i save the page and open it again the value is again getting set to default value, i don't why this is happening? This is settings.ts file, where i am setting the value=20, on saving and opening the report again value is getting set to 20 (showing 20) but its still taking up the previous value which i have set it (not default value). How to resolve this issue?
Custom Shape MAP Fill color not filling
Hello all, from Portugal 😄 I've got a Custom MAP Shape, that should be filled, with a color from a column in a sharepoint. All the connections are working and the report is loading the Sharepoint list. The probllem is that the color declared on the sharepoint column is NOT filling the custom shape with the choosen color. Any help yould be appreciated! Tks in advance!
