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:
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
Create US county level map
I'm working on poverty data in Washington state and am having issues trying to create a chloropleth map to visualize the rate of unemployment in each individual county. The map is intended for the public's use so it needs to be easily understandable. These are maps that I've tried: - Filled map -- the lack of borders around the counties make the map hard to understand since different shades denote different severity of unemployment rate. - Shape map -- I have not been able to show only and all the counties in Washington on the map. I've tried using the State and County FIPS code, but a number like '0037' get automatically converted to '37', which is a different code.This might be the best way to achieve what I need if I can map out just the counties in Washington. - ArcGIS map -- This comes closest to the the visual I want to create. However, the colors are extremely jarring and words on the map are hard to read. Below is an example of what the ideal map looks like: Any insights on how to create this map would be so appreciated.Treemap visual with circle shapes instead of rectangles
I would like to know if there is a visual on power BI, very much like the treemap visual, except with circles as the shape instead of rectangles. The main property of the visual I'm looking for is for each category within the relevant dataset to have its own circle, and the relative size of that circle should scale with a DAX measure of my choice. The data I'm visualising is very basic and one dimensional, so I don't want to give it an x/y axis as is the case with a bubble chart. Crossposted here: https://community.fabric.microsoft.com/t5/Desktop/Treemap-visual-with-circle-shapes-instead-of-rectangles/m-p/3650867#M1194464ArcGIS Map visualisation legend colours
I have an ArcGIS Map visualisation that is displaying my data points with no issues. I have set the legend , latitude, longitude and Tool tip text columns and it all works fine. What I want to do next is custom specify the colours for the circles on the legend. At the moment the visualisation just takes my theme colours and applies them to each value in the legend in sorted order. I would like to specify the colours myself so that the colour is a visual gradient of the legend values "seriousness". When I open the Format Legend on the Visualizations pane and expand the Legend option, the only choices it gives me are Options, Text and Title. Nothing for Values. How do I custom specify colours for legend values on an ArcGIS Map visual?
Custom Slicer for Different Time Intervals in a 24 hour Format
Hi Power BI community, I am creating a report in which i have to create a custom slicer for various day ranges along with the time interval. The user of the report must be able to select the day range and time interval to check the historical data that filters the line chart accordingly. I tried to create one slicer with the DAX measure and for time interval I am using the Relative time slicer. I am replicating a web page which enables user to select a particular time stamp along with the Date. I have attached screenshots of the web page that i am trying to create. if you have any other approach method to create the Slicer. please let me know. Looking forward for any suggestions and help. Best regards, Ibrahim
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.
