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.
Dear all,
I'm new in deneb. I try to do sorting based on user selection from a slicer. In the slicer I have 2 values: By group or By increase
I have 2 tables. 1 for products and 1 for categories. In the categories table I have group column. In the product table I have increase measure.
What I would like to accomplish is conditional sorting in my deneb.
Here it is what I did try but it seems I do not find the right syntax
"layer": [
{
"mark": {
"type": "text",
"angle": -90,
"baseline": "middle",
"align": "left",
"size": 10,
"color":"grey"
},
"encoding": {
"text": {
"field": "groupdisplay",
"type": "nominal"
},
"x": {
"field": "Category",
"sort": {
"op": "mean",
"condition": {"test": "datum['selectedorder'] = 'By increase'", "value": "Value"},
"value": "groupdisplay"
},
"type": "nominal",
"axis": {
"labelAngle": -45,
"grid": true,
"offset": 10,
"title": null
}
},
"y": {
"field": "Value",
"type": "quantitative",
"axis": {"title": "Value"},
"scale": {"zero": false}
}
}
}]
Thank you for your help 🙂
You cannot have two tables. Deneb only recognizes a single dataset based on the items in the Values well.
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...
User | Count |
---|---|
77 | |
76 | |
44 | |
31 | |
26 |
User | Count |
---|---|
97 | |
89 | |
52 | |
48 | |
46 |