The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi,
I have a tricky requirement for my dashboard to show values from two different text columns based on the slicer selection. I found so many close results for my search but everything I found is for Integer type columns like SUM(Column A) to return results by measure but my requirements is for Text column (Column for Comments)
So, if there is no selection in the Slicer, then I want to show the Text values from Column A and if there is any value selected in the slicer then I want to show the values from Column B.
My basic Measure to get the result is SlicerCheck_Comments = IF (ISFILTERED('Table 1'[HUB]) = FALSE() , MAX('Table 1'[Comments A]), MAX(Table 1'[Comments B]))
This is not working becasue it returns only one row because of Max function, without Max function I am unable to add a column, please help me achieve this.
If there is no selection like below then I want to see values from Comments A column
If there is any selection, I want to see values from Comments B column
Please help
@Selva_Power_BI , if comments are not summarized, then you have use bookmarks
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
Or
Dynamically change chart axis in Power BI
https://www.youtube.com/watch?v=6jeSIRpjv0M
https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/
If they are measures then
measure slicer
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...
https://www.youtube.com/watch?v=vlnx7QUVYME