User Profile
Mahendran_C_S
Helper I
Joined 5 years ago
User Widgets
Contributions
Filter the visual to last 12 months based on the date range selected in the visuals slider
Hi, I have a requirement to filter a visual to 12 months where that 12 months period ends at the end of date range sliced in the line chart visual axis. The above screenshot is a visual which has the date as its x-axis where the zoom slider is enabled so that the user can select the date range. Also, I have a selection that has 12 Months and All. If the user clicks on 12 months the line chart filters the visual to 12 months . for example, The slider in the visual is between Aug,2019 to Oct,2021 and the 12 Months selection is selected. The visual should show data for Nov,2020 to Oct,2021 taking sliders last month as the 12th month. If All selection is selected the visual should show the data for date range in the slider i.e from Aug,2019 to Oct,2021 according to this example. It would be great if anyone suggest any solution using DAX measures or some other ways to achieve this requirement. Thanks in advance.Unable to Launch/Open the Power BI Desktop
Hi Folks, I have updated the Power BI desktop from Microsoft Store. After the update when I click launch I was not able to launch or open the Power BI desktop application. It shows the following error. Kindly, anyone help me in resolving this issue. Thanks in advance.Re: Converting Number column to binary and map the binary 1's based on position with other table/values
Since I am a beginner to power query M language.I was not able to achieve the requirement with the above solution. In the above solution, a value is passed and the final result is displayed in the list. What I wanted is I have to transform the entire column with the mapping country name as string/text . For the column below : Number 39 78 I want my resultant column to be : Resultant column India,Canada,France,Singapore Canada,France,USA,Malaysia I don't know how to map the values with the country name and display them in the resultant column as a string . Could you please help me out in solving this? Thanks in advance.Converting Number column to binary and map the binary 1's based on position with other table/values
I have a column with data type whole number with numbers like 39,191,68 etc... I have a requirement where I have to map these values with another table or list. The mapping table contains : Number Country Name 1 India 2 Canada 3 France 4 USA 5 UAE 6 Singapore 7 Malaysia Eg. How this mapping works with value 39 is 1. Have to convert the number 39 into binary 100111 and start mapping for bit 1's from the right side position. 2. Let's say for this 100111 starting from rightmost position side 1 maps to the mapping table with number 1 where the country is India and when bit 1 occurs in 2nd position from the right side it maps to country Canada and so on. Finally, I want my column to be like the mapped string instead of the number 39. 39 - India,Canada,France,Singapore Could , anyone help me out to solve this requirement using power query M language in the power query editor or using DAX? Preferably looking to solve in the power query editor.Re: Matrix with Dynamically changing rows based on slicer selection
Anonymous My requirement is to select rows like country name, project name, and store name, etc., But the above refers to only measures which will be displayed if the selection occurs. Is it possible to achieve dynamic row selection for a matrix with a drill-down option in the selected order in power bi?Re: Matrix with Dynamically changing rows based on slicer selection
amitchandak I couldn't get you. Can you share a reference link or tutorial for the solution you are mentioning? I am looking for a selection-based solution rather than using bookmarks. Because I have multiple columns/dimensions for that selection.
