Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Distinct count -sum

Hello

 

i have couple of questions.

 

can we group column based on measure  show in pic.

can column labels change dynamically when month changes in last 3 months for measure a ^& measure ?B

distinctcount-sum.PNG

3 REPLIES 3
V-pazhen-msft
Community Support
Community Support

@Anonymous 

It is recommended to create measures based on the existing columns to make visuals dynamically change.

Best regards
Paul Zheng

camargos88
Community Champion
Community Champion

 @Anonymous ,

 

Have you thought about using matrix instead of table ?

You can use a column value as header, it will give you a dinamic header based on your column values.

 

Ricardo



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



edhans
Super User
Super User

No. Column lables cannot dynamically change. You can have dynamic text in a Card using normal text formulas, but column and row labels are based on the database you have loaded. You can conditionally format the data using measures to determine if it was changed in last 3 months, but that changes the format of the values, not the column info.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.