Add conditional formatting or action customization for column headers in matrix and table visuals
I would like to suggest adding the option to conditional format column headers in matrix and table visuals as hyperlinks to enable quickly navigating to a web URL or a page within the report. For example, I have a report page that acts as a heat map with various columns show the health of each client (rows) in each of the various categories (columns). Subsequent pages in the report provide more detailed metrics and information for each of the corresponding columns on the heat map. I want to make it so the user can click the heat map column header and be redirected to the corresponding details page in the report. This is one of many instances where being able to conditional format a column header with an action or hyperlink would be helpful. For the above example, I do have a workaround in place, using "invivisible" action buttons, however these do not move with the headers in the event we need to scroll to the left or right in the matrix or table visual so I am limited to only showing the number of columns that can fit in the view without scrolling left to right.Hide/show Column in Table/Matrix Visual (on Report and on Web)
This option is possible in QlickSense, but unfortunately not in Power BI. Like in QlickSense you could then work with a loose slicer: the user can show/hide the columns of his choice. So sad to see that this is still not possible in Power BI.
Table Visuals - Conditional Formatting Rules Requires a Range on Greater Than
For conditional formatting in the Table visualization (perhaps others), when using Greater than or Equal to within the Format by Rules option, the current desktop Power BI version requires an endpoint on the range (either less than, or less than or equal to). This may require the user to enter an arbitrary high number so that all possible values Greater than the the specified value be addressed. In other words, please remove the requirement that the Less Than value be provided when the Greater Than (or Greater Than or Equal To) option is selected for the rule. Thanks.
Improved table visual - dynamic column names
Hello, I have a table similar to this one I need a comparison table ("1 vs 1") with 2 columns based on Year column, using two slicers for years. So, I've created 2 tables for each slicer based on the year column using this thread: Re: Two slicer on same column FilterTBL-Base = DISTINCT('DataTable'[Year]) FilterTBL-CompareTo = DISTINCT('DataTable'[Year]) And for each "filter table" I have created the corresponding measure to know the selected value: SelectedYear-Base = SELECTEDVALUE('FilterTBL-Base'[Year]) and SelectedYear-CompareTo = SELECTEDVALUE('FilterTBL-CompareTo'[Year]) Now I am able to calculate the "base total" and the "total to compare to" in my data table using the following measures: TotalBase = SUMX(FILTER('DataTable','DataTable'[Year]=[SelectedYear-Base]),'DataTable'[Cost]) and TotalCompareTo = SUMX(FILTER('DataTable','DataTable'[Year]=[SelectedYear-CompareTo]),'DataTable'[Cost]) So the entire structure looks like this: The calculation works as expected: The only problem it bothers me, is that the final table should have the column names based on the slicer selections. In picture above TotalBase should display "FY_2010" and the TotalCompareTo should display "FY_2011". I could obtain this by manually renaming the measured used in the value field, but if the user select other options in the slicer I have to rename the fields again. As I could rename the field manually, could you consider a way to "set its name" by another measure value (ex. SelectedYear-Base)? For the moment the only "workaround" is an card visual with the same font/size as the other colum titles from the table but loosing in this way the "focus mode" for that table, sorting etc... Kind Regards, Lucian
