My best solution was to have cards displaying the range values generated above the slicer, so the user could define a range and then plug the resulting values into the slicers themselves. For example, if I have measures defining a range of values (+5% and -5% of a selected store's sales), I cannot feed these into slicers to automatically filter the rest of the page. Mathur did so with a concatenated list I was looking for a bar chart.īasically, my problem here is that Power BI does not allow measures to dynamically filter slicers. For example, you can use the relative date slicer to show only sales data that's happened within the last 30 days (or month, calendar months, and so on). With the relative date slicer or relative date filter, you can apply time-based filters to any date column in your data model. So, a user could click on a store, then select a range (+/-X%) to apply to the sales, and find the stores whose sales are within that range - Mr. APPLIES TO: Power BI Desktop Power BI service. Mathur, referenced above, by using a disconnected table of percentages and then using that disconnected table to create measures that are used as filters in a calculate function. Then, click on Options, as shown in the above image. Go to the File tab in the Power BI Desktop and select Options and Settings. I would greatly appreciate any suggestions.īy stores with "similar" sales, I mean stores with sales that are plus or minus X% from the sales of the store selected. For adding Power BI filters on dashboards to pane or to all the new reports created using Power BI, we have to configure the filter settings in the Power BI Desktop. I've also tried multiple disconnected tables, but I'm struggling with that as well.īasically, how can a Power BI user select an observation and have a visualization display not only that selection, but also the observations that are most similar to that observation? This would be very helpful for helping clients compare apples-to-apples within a large, diverse dataset. It may be possible to use the CONTAINSSTRING function to filter the data table only to the rows with store locations identified by his code as similar (through the concatenated list), but I have not figured out how to do it. His pbix file is attached to this earlier thread. Resolved <15 CALCULATE ( Count P1,FILTER (Table1,Data Days to Eradicate < 15. To clarify, I don't want to aggregate results across the similar observations - instead, I want to display the individual results of each similar observation, based on a dynamic selection of an observation to be a very helpful solution to a related question, producing a concatenated list of the names of similar stores, based on (1) selecting a store in a slicer and (2) selecting a range of variation from a disconnected table. Please create a measure using COUNTBLANK DAX function for your scenario. I am trying to create a dashboard that allows users to select an observation (for example, a store location) and automatically produce a bar chart displaying only similar observations (for example, the individual sales of other store locations with similar sales).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |