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.
In QlikView, we are able to create measures which flag certain information. When you drop the flag into a table, there is an option to hide the output column. Resulting in a custom manipulation of the table by hiding output columns flagging only information required. Below is sample data (Measure = creating flag / Table 1 = source data / Table 2 = expected output).
Is there a way for us to hide the measure output column?
(Measure = Creating Flag)
Pattern Flag =
SUMX(
SUMMARIZE(
ALLSELECTED(PizzaOrders),
PizzaOrders[transaction_id], "Date",MAX(PizzaOrders[transaction_date])
), IF(
[Date] >= CALCULATE(MIN(PizzaOrders[transaction_date]) )
&& [Date] <= CALCULATE(MAX(PizzaOrders[transaction_date]) )
,1, BLANK()
)
)
(Table 1 = Source Data)
transaction_id | transaction_date | status |
pizza1 | Wed. Nov 25, 2020 | New |
pizza1 | Fri. Nov 27, 2020 | In Progress |
pizza1 | Mon. Nov 30, 2020 | Baking |
pizza1 | Tue. Dec 1, 2020 | Boxing |
pizza1 | Fri. Dec 4, 2020 | Complete |
pizza2 | Thu. Nov 26, 2020 | New |
pizza3 | Wed. Dec 2, 2020 | New |
pizza3 | Wed. Dec 2, 2020 | In Progress |
pizza3 | Thu. Dec 3, 2020 | Complete |
pizza4 | Mon. Nov 30, 2020 | New |
pizza4 | Fri. Dec 4, 2020 | Canceled |
(Table 2 = Expected Output)
transaction_id | transaction_date | status | Pattern Flag **HIDE THIS COLUMN** |
pizza1 | Friday, December 4, 2020 | Complete | 1 |
pizza2 | November 26, 2020 | New | 1 |
pizza3 | Thursday, December 3, 2020 | Complete | 1 |
pizza4 | Friday, December 4, 2020 | Canceled | 1 |
Any advice will be greatly appreciated.
Solved! Go to Solution.
If you just want to apply that flagg condition on your table and do not want to see on the table then the best way to apply the flag as a visual filter.
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-report-filter
Regards,
Manikumar
Proud to be a Super User!
If you just want to apply that flagg condition on your table and do not want to see on the table then the best way to apply the flag as a visual filter.
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-report-filter
Regards,
Manikumar
Proud to be a Super User!
Hi @win_anthony ,
I guess the first question would be: What are you using the flag column for? If it's for calculating other values from or for filtering/slicing, then it doesn't need to be there, it can be worked into other measures or applied as a filter in other ways.
If you really just want an invisible column in your table, then I think the closest you would get is to rename the measure in the values list to " " (space), then turn off auto-size column widths on the table and adjust that column width to zero. You could also go to Field Formatting on the format tab and set all the colours of that field to the same as your background for good measure.
Pete
Proud to be a Datanaut!
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 |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |