This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more
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.
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.
Putting the customer in the columns is not a great idea. You can avoid the issue by swapping the dimensions.
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.
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 24 | |
| 22 | |
| 20 | |
| 18 | |
| 14 |
| User | Count |
|---|---|
| 45 | |
| 38 | |
| 24 | |
| 21 | |
| 20 |