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 ... View more

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.  ... View more

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.   ... View more

Would like to be able to have the value of a slicer be shown on table/matrix columns/rows, or in the Legend text, when the chart is made up of multiple measures. See attached pic. I would like to be able to see "March Forecast" everywhere that says "Forecast 1".   ... View more