custom filter

4 Topics

Customizing tool tip for table value
Hello! Upon reading the forum and watching many tutorial videos, I haven't seen any examples for tool tips related to table filtering. I would like to hover over a table value, and have a tool tip to display information tied to that specific value. Currently, I have a tool tip page, tool tips turned on for the page and tool tip table but when I hover over the value on my main page, it shows the entire tool tip page rather than filtering the table based on what value I am hovering over. Given the example below, if I hover over '1', I'd like for the tool tip to only display '1''s from column 1 and the corresponding column 2 values. Main page Column 1 1 2 3 4 Tool tip page Column 1 Column 2 1 89 1 93 1 46 1 57 2 65 2 89 3 93 3 46 4 57 4 65 Desired outcome Tool Tip Page Column 2 1 89 1 93 1 46 1 57
Solved
ssjordan95
2 years ago Place DAX Commands and Tips
3.8KViews
0likes
6Comments
Dax formula to filter table
Hi, I have text data visualised in a table in Powe bi. European Union is also available in data as a country. Requirement is to custom filter table in a way that if user select any EU country from slicer, table should show selected country + EU. In case non-EU country is selected, table should only show selected country. I have created a new table, not related to data model with list of countries and created below measure: Filter=If(selectedvalue(fact_table[country])="European Union"||Selectedvalue(facr_table[country] in values(unrelated_table[country]),1,0) I have applied this measure as visual filter to table visualisation and set it's value to 1. It's partially working and showing European Union when I select an EU country or non-EU country from slicer. Kindly help me to modify this calculation so it only shows European Union when an EU country is selected.
Solved
Ughd
3 years ago Place DAX Commands and Tips
1.4KViews
0likes
7Comments
2 Measures on same line graph
I have 2 rolling 14 day average calculations and Im hoping to display them (highlighted) on the same line graph: However I've tried to create a date bridge and another table to relate to and still no luck with either approach. Where it should look more like this: Can anyone help with this? SEE FILE ATTACHED https://www.dropbox.com/s/ksi9fm0kbzpj1hg/Notification%20vs.%20Epi.pbix?dl=0
Anonymous
5 years ago Place DAX Commands and Tips
919Views
0likes
1Comment
DAX for Custom Filter to Select Past Months & Current Month's Latest Date
https://drive.google.com/file/d/1ZBTilbeJxPISCZsqlv3FH2Qffvz09k1a/view?usp=drivesdk This is a sample of my dataset. When data is refreshed today (May 24), data will be available until the previous day (May 23). for the current month, data will be updated incrementally (day wise status). for example - for all departments, I have day wise status. (May 1, May 2, May 3, May 4..... May 31 ) At the end of the current month - May, day-wise status is deleted and only May 31 status (final for the month) is stored and the day wise status is started for June. I want to show Past months & Current Month -latest date status for monthly trend visual. Currently, I have put "Latest data" in Filters and Selecting past months and "Latest data". Issue - At the beginning of Next Month, the Filter does not include "May data" and I have to be select manually. How to achieve automating this selection so that all past months are selected automatically along with Current Month Latest date?
Solved
bboobe
6 years ago Place DAX Commands and Tips
2.7KViews
0likes
10Comments