Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to develop a custom visual (Kanban Board sort of visual) and facing below limitations or perhaps my lack of knowledge in the dataViewMapping and its customizations , the common between the two observations, is that both are impacted by the chronological order in which fields are dragged by users into the visual fields wells at runtime
any hint on what i am missing here would be much appreciated
1. the option to "show items with no data" seems to depend on the chronological order in which columns are added to the visaul at runtime, i.e. the first column user adds is the one used to left join other columns , data values from other columns which doesn't have related data in the first column will not be visible on the dataView.table.rows collection
e.g. if I have two tables stages and features with one stage to many features relationship , if I drag stage label first for instance to the visual, I will have all stages present in the table even if they don't have respective featuers, while if I add a feature title first , stages with no features will not be present
2. The column entity in dataView.metadata.columns collection doesn't seem to have an obvious attribute that designate the order of appearance of the column in the visualization fields wells , the columns are also ordered by the chronological order in which the user adds them to the visual at run time even if the user reorders them later after addition
The data model
Stage.label dragged first to the visual
DataView while stage.label dragged first
Stage.label dragged late to the visual and “show items with no data” checked
Reordering fields in “card content” well later after dragging has no impact on their metadata or appearance in resulting dataview table
DAX Studio can be used to capture queries, you may have a look.
thanks for the hint, it provides a good insight into another topic, but the problem is not in preparing the dataset via DAX. the dataset is good, it is only the order of dragging fields into the visual generates different results, i assume the dataset should be resilient to the order of fields addition to visual.
what i did last is:
thanks anyways
I am new comer here and trying to develop a customer visual (sort of Kanban board) , order of dragging fields into visual dictates resulting dataview irrespective of user reordering actions after first drag!! Am I missing something here or is it sort of missing capability?
1. first field dragged is used to left join others, hence option "show items with no data" is not producing expected results if field of choice was dragged into visual later
2. neither metadata nor column order of appearance into dataview table reflects the order in which user chooses the columns to appear one after the other
sample data in next diagram "features" are grouped by "stages" (one "stage" to many "feautres" relationship), if stage "label" field is dragged first, dataview table will contain row(s) of data for "stages" with no "features" , if "label" is added late, no rows for "stages" with no "features" are found in the dataview table. (sample reports and resulting dataviews are in next screenshots)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
16 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
29 | |
3 | |
3 | |
2 | |
2 |