Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
7 | |
6 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |