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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
vanessafvg
Super User
Super User

Multiple Banding - one table

This could be a redundant question, i am just questioning if there is a better way to do this.

 

I have one banding table, which i want to link to multiple calculated columns in one table, just for simplicity and standardization.  However, that probably doesn't make sense as when you place the banding on a visual, which calculated column is it referring to?  Een if it has more than one relationship (active and inactive), which one is it pointing to?   Is creating the  descriptive text banding on each calculated column the best way to do this or is there another more elegant solution?  What i like about the banding table is that i can create a sort order easily without having to create 2 banding columns for each scenario.

 

hope that makes sense.  TIA

 

 

Capture.PNGcapture2.PNG

 

 





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




2 REPLIES 2
v-ljerr-msft
Microsoft Employee
Microsoft Employee

Hi @vanessafvg,


I have one banding table, which i want to link to multiple calculated columns in one table, just for simplicity and standardization. 


I'm not sure I can understand this totally. Smiley LOL

 

What do you mean about "link to multiple calculated columns in one table"? Could you be more precisely with it using some samples or figures?Smiley Happy

 

Regards

1.i have multiple calculated columns in a table which link up to a table called banding to show the banding

2. i have another table calleding banding 2 which i want to connect via a relationship to these multiple columns

 

i could handle all the banding for these columns in a switch statement.   however i am wondering if there is a way to link one table to multiple calculated columns in a table - sort of like inactive relationships with measures but this is with columns.





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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