How to order slicer values by another column within each group of the current column
Hi everyone, I have a table that looks like this: WELL FORMATION DEPTH A B_top 1 A A_top 2 A C_top 3 B B_top 45 B A_top 48 B C_top 50 C B_top 101 C A_top 120 C C_top 135 In Power BI I want to build a slicer for FORMATION. The issue: the slicer always shows the formations alphabetically, but I want them ordered by their depth within each well. I tried creating a Formation_Order column using RANKX, but Power BI gives the error "There can’t be more than one value in Formation_Order for the same value in FORMATION" (because the same formation appears in multiple wells at different depths). What’s the correct way to set up a slicer that respects the per-well depth order? Do I need to build a separate dimension table for slicer values, with WELL + FORMATION combined, and then sort by depth? Or is there a simpler trick to achieve this? Thanks a lot for your help!Custom date slicer with persistProperties commented
I’m currently stuck on a Power BI visualization issue related to bookmarks and slicers, and I have a unique requirement. I have 3 funds: F1, F2, and F3, and I’ve created a Button for each fund. Each fund has 3 different subpages: Overview, Projections, and Portfolio. Each subpage contains visuals specific to that fund. (Attached sample image) I’ve created bookmarks accordingly. However, the problem is with the Date slicer. Since bookmarks preserve the slicer’s state, the date selection is always fixed to what was selected when the bookmark was created. I want the Date slicer to always default to the latest date from the date_dim table, regardless of the bookmark. I tried unchecking the Data option in the bookmark, but that causes other issues. I have hidden slicers that dynamically filter the selected fund when the corresponding button is clicked. Disabling the Data option prevents those fund slicers from working correctly. Each visual should display data only for the respective fund selected. After some research, I found that this is a known limitation in Power BI — you cannot exclude only one slicer (like Date) from a bookmark while retaining others. As a workaround, I explored the idea of customizing a visual, such as the slicer from this GitHub repo: https://github.com/microsoft/powerbi-visuals-timeline I commented out the this.host.persistProperties line to stop it from persisting the selection state. But after building and uploading the custom visual to Power BI, it doesn’t seem to work , is there other way to solve this problem? I need a date slicer with provision to exclude persistent or any different approach to this problem
Industry Slicer - Blank is appearing
Hi, We have cleaned the industry field and there are few blank fields, so replaced null = No Information Kindly check the attached image as well. When I add the Industry Table in slicer. Ideally, it shouldn't display (Blank), but for some reason I can see both (Blank) and No Information Field in the slicer. I've added a card to show the value of slicer. When I select (Blank), it's showing number. (Count of Blank fields in the table) When I select "No Information" field, it's showing zero. As you can see in the Industry Table, I can clearly see "No Information" Field Highlighted in yellow and within red box. Can somebody help me to understand what's the problem here ? How to solve this issue ? Your inputs are much valuable to me. Thanks in Advance. Best Regards Raja Sahir_Maharaj
