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

Data Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more

Reply
Substance1001
Frequent Visitor

Dynamic Rows Valeus False

Hi,

I have to create Rows Selection form DAX and Link Relation by Index form table[SalesFact] to table[Rows Selection]

now i can selection slicer to change row but my data is false

How to solve this problem?

Thanks for answer.

 

Need data form A table like B table.

2023-12-25_8-31-10.png

 

5 REPLIES 5
lbendlin
Super User
Super User

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Sorry for my problem,

Now i got attachment PBIX file form this comment.

Please advise.

 

https://drive.google.com/file/d/1Gn71DP4OtP1yBYbKCU8AfROHHcF7PaYv/view?usp=sharing 

Thank you for the sample data. Please explain the logic for getting the values in Table B, for example S-002 and A11003

 

You can also see the blue i - always a bad sign.

 

lbendlin_0-1703718598950.png

Putting the customer in the columns is not a great idea. You can avoid the issue by swapping the dimensions.

 

lbendlin_1-1703718671854.png

 

In table B i take row and column from table Salefact, This data is correct but i need to change Row and Column from slicer by custom table(Dax from Pic1) now my data is all the same values.

Sorry, I still don't understand the setup. I hope someone else can help you further.

Helpful resources

Announcements
Fabric Data Days is here Carousel

Fabric Data Days 2026

Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.

May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.